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..
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 |
Explain how abinitio eme is segregated?
How to create repository in abinitio for stand alone system(local nt)?
EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer
How to run a graph infinitely?
What is publickey and private key?what is the use of this two keys?
What would be the next step after collecting the data?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
What are the fundamental blocks of co> operating system of ab initio?
How can you import XML repositories exported from different tools like ODI
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Describe how you would monitor and control database physical file size and growth?