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
- 24844 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 relation between EME , GDE and Co-operating system ?
To which project that prefix will set is to private project or public project or both?how and where to set?
Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is populate file(pid,sid,Adress) I want (cname & total poplation) how i can get the output please help me Thank you
What is local and formal parameter?
List out some of the air commands used in abintio?
Describe which system or process elements you would review when trouble-shooting general server slows ?
Can you use scan to generate sequence number ? How to use in abinitio graph?
What is regex (lookup)? When you should use it? How to use in abinitio graph?
What is the purpose of having stored procedures in a database?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?
What is difference between force_error & force_abort? How to use in abinitio graph?
Teradata 
