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
- 26775 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What is the difference between a scan component and a rollup component?
What is common among data validity and data integrity?
What is air-project parameter ?
Can anyone give me an example of realtime start script in the graph?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
How data is processed and what are the fundamentals of this approach?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
How can a graph be run infinitely?
How can you export a component’s internal parameters ?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
Have you worked with packages?
What kind of layouts does abinitio support?
State the working process of decimal_strip function?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
