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
- 27009 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
how to insert/update a csv file by comparing it with another csv file?
What is data mapping and data modelling?
Mention what are the different types of parallelism used in abinitio?
What are differences between different versions of co-op?
What parallelisms does Abinitio support?
Runtime behavior of Normalize and Reformat
What is air-project parameter ?
How to add default rules in the transformer?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
What is conduct>it?
Give one reason when you need to consider multiple data processing?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
How to add default rules in transformer?
Why might you create a stored procedure with the with recompile option?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
