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 / avijit
Filter the header and trailer records by using FBE or you can use dedupsort.
i/p-->Dedupsort(Keep 1st)-->Dedupsort(Keep last)-->Reformat(out.Rank::next_in_sequence())-->Sort(Rank,Desc)-->o/p
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Difference between informatica vs ab initio?
Pdl with an example?
can we perform checkin and checkout through sandbox?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What is the architecture of abinitio?
To which project that prefix will set is to private project or public project or both?how and where to set?
What is the use of the co> operating system in ab initio?
What do you mean by a transaction file and how it is different from that of a sort file?
What are “business rules” in ab initio business rules environment (bre)?
What are the different types of partition components in abinitio?
Explain batch processing in ab initio?
What are the types of data processing you are familiar with?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
What is the function you would use to transfer a string into a decimal?
What metadata importer can do in ab initio?