Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 26945 Views
- TCS, I also Faced
- E-Mail Answers
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
What does it mean by the term 'sort component'?
How do you improve the performance of a graph?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
What are the different types of partition components in abinitio?
What are the benefits of data processing according to you?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
What is the difference between a scan component and a rollup component?
What is sort component in abinitio?
Explain what is sandbox?
Explain batch processing in ab initio?
What is the difference between rollup and scan?
Explain how abinitio eme is segregated?
What are the functions of the replicate and dedup component?
