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
- 26844 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 the use of catlog or catlogfile?
What is broadcasting and replicate?
What is difference between force_error & force_abort? How to use in abinitio graph?
What do you understand by local lookup?
What is a partition and what are the different types of partition components in abinitio?
Why might the optimizer use a table scan when an index is available?
what is SSH?What is the differences between the SSH,SSH1,SSH2?
In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?
what is the difference between the .dbc and .cfg extensions and give any clear information ?
Mention what are the different types of parallelism used in abinitio?
What are the steps to create a repository in ab initio?
How will u remove header record? How will u remove tailer record?
Teradata 
