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
- 25908 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What information does a .dbc file extension provides to connect to the database?
Mention what dedup-component and replicate component does?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What are the Types of parallelism in detail?
What is broadcasting and replicate?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
Have you ever encountered an error called “depth not equal”?
Explain how abinitio eme is segregated?
How to add default rules in transformer?
What is the difference between sandbox and EME?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What are the operations that support avoiding duplicate record?
Describe the evaluation of parameters order in ab initio?
What are the features of ab initio?
Can you explain the co>operating system’s processing model?
