One file contains header,body,trailer records and header in
a single row as well as trailer too.How to segregate these
header,trailer and body records and once it gets
segregated,i want to make the body data in reverse i.e if i
have 10 body records,the 10th record should be the first
record,9th record should be the second line,etc..
Answer Posted / dhirendra
Segregate the header, trailer & body by either using part
by expression component or using filter by exp. Use
next_in_sequence() function to a new column of the data
record. Use sort on descending to sort the data on the
next_in_sequence() column.
Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
Difference between output_index and output_indexes in reformat
How can you force the optimizer to use a particular index?
Explain the difference between the truncate and delete commands?
Mention what is the syntax for m_dump in abinitio?
You can ask about different vector functions. How to use in abinitio graph?
What are the different types of parallelism used in abinitio?
Explain how abinitio eme is segregated?
What is a deadlock and how it occurs?
What is sort component in abinitio?
Can anyone give me an example of realtime start script in the graph?
What is a rollup component?
Mention what is a partition and what are the different types of partition components in abinitio?
What is is a data flow graph?
What are the different types of parallelism in ab initio?
Within a cursor, how would you update fields on the row just fetched?