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 / mohankumar

Use dedup sort to remove header and trailer records. Next
by using scan component generate seqeunce number, then sort
according to the seqeunce number(Desc).

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the kinds of layouts does ab initio supports?

737


Have you used rollup component? Describe how.

823


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

854


What dedup-component and replicate component does?

961


Explain the difference between the truncate and delete commands?

815


What are the different types of partition components in abinitio?

1029


What do you mean by the term data warehousing?

801


How to create repository in abinitio for stand alone system(local nt)?

927


how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

1700


What is the difference between formal and export parameter? Export at what secenario we are going to use?

2359


How to compare two dmls in abinitio

1513


What is the syntax for m_dump in abinitio?

1295


How scientific data processing is different from commercial data processing?

815


What are the steps to create a repository in ab initio?

928


Why do you think data processing is important?

835