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
- 26761 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 |
What is a partition and what are the different types of partition components in abinitio?
What is the language used in Ab Initio ?
What is a deadlock and how it occurs?
What are the benefits of data analyzing?
what is the difference between the .dbc and .cfg extensions and give any clear information ?
How to move data from developement to testing and testing to production?
1 Answers BitWise, CTS, Satyam, Wipro,
What is $mpjret?
What does it mean by the term 'sort component'?
What will be the output of using partition by Round-Robin after the partiton by key in ab initio?
What is a data processing cycle and what is its significance?
To which project that prefix will set is to private project or public project or both?how and where to set?
What is the significance of ‘mp run’ command ?
Teradata 
