Can any body give me the clear explanation about how to
separate header,trailer and body records in Ab Initio?
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 partition?
What is the latest version that is available in Ab-initio?
How will you check the latest versions in EME?
How to move or copy the project parameter or project object to my sandbox?
Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?
What are the co> operating system’s assorted library of integrated components?
What is is a data flow graph?
What are the different types of partition components in abinitio?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
how to prepare scd2 in abinitio
)what is wrapper script?where it is going to execute and why we go for wrapper?
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump