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..
Answer Posted / 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 |
Post New Answer View All Answers
Can anyone give me an example of realtime start script in the graph?
What is the importance of eme in abinitio?
Describe what the SQL Server tempdb and tlog files are used for?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
How scientific data processing is different from commercial data processing?
What is a rollup component?
What exactly do you understand with the term data processing and businesses can trust this approach?
What are the operations that support avoiding duplicate record?
What is data mapping and data modelling?
What is the purpose of having stored procedures in a data-based?
Explain what is de-partition in abinitio?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
What do you understand by a cartesian join?
Why might the optimizer use a table scan when an index is available?
What is m_dump?