Can any body give me the clear explanation about how to
separate header,trailer and body records in Ab Initio?
- 2 Answers
- 17132 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anvesh vuppu
You will be having an indicator field(sth like
record_indicator which will identify whether the record is
a header or trailer or detailed.) in your DML. So, use a
partion by expression component in your graph and based on
the indicator values, separate the records.
i.e. give the expression in the PBE component sth like:
if(record_indicator == "H") 0 else if(record_indicator
== "T") 1 else 2;
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / ramakrishna
use next_in_sequence>=1 in reformat to remove header and
use entire record as a parameter in dedup and eliminate the
trailer record
| Is This Answer Correct ? | 5 Yes | 4 No |
What is a deadlock and how it occurs?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
how to create a new mfs file? where will we specify the number of partition eg 4 way ,8 way?
What is difference between API
2 Answers CitiGroup, IBM, TCL,
What is the difference between sandbox and EME?
I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?
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?
How Does MAXCORE works?
How to Improve Performance of graphs in Ab initio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
How will you check the latest versions in EME?
) Layout? What is the Dataset & Program Component Layout
Teradata 
