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
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
What are “business rules” in ab initio business rules environment (bre)?
What is the importance of eme in abinitio?
What is data encoding?
What are the operations that support avoiding duplicate record?
What is conduct>it?
Do you think effective communication is necessary for data processing?
What is common among data validity and data integrity?
Explain what is sort component in abinitio?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Mention what dedup-component and replicate component does?
What is sandbox?
Explain about ab initio’s dependency analysis?
How to add default rules in transformer?