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 / 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
explain the environment varaibles with example?
What is the function that transfers a string into a decimal?
What are the facts that can compromise data integrity?
can we perform checkin and checkout through sandbox?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What do you mean by the overflow errors?
How can you export a component’s internal parameters ?
Describe what the SQL Server tempdb and tlog files are used for?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Can you explain data flow graph with an example?
what is the project environment(for each project the environment is same or different to different project)?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
Mention what is the syntax for m_dump in abinitio?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
What is MAX CORE of a component?