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
- 27029 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
Answer / rushikesh deshpande
Segregate header,trailer and body by using Reformat with
count 3.and use next_in_seq() to assign number and sort it
in descending order
| Is This Answer Correct ? | 2 Yes | 0 No |
11. What is the use of allocate()?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
You can ask about - meta pivot, leading records, read & write multiple files component ? How to use in abinitio graph?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
what is the difference between the .dbc and .cfg extensions and give any clear information ?
How you can delete an object from EME data store ? How to use in abinitio graph?
Explain batch processing in ab initio?
Mention what the difference between “look-up” file and “look is up” in abinitio?
How to run a graph infinitely?
what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?
how to insert/update a csv file by comparing it with another csv file?
Explain what is the architecture of abinitio?
Teradata 
