Interested to Buy Any Domain ? << Click Here >> for more details...
Can any body give me the clear explanation about how to
separate header,trailer and body records in Ab Initio?
- 2 Answers
- 18713 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 |
How will you use EME for view or publish metadata reports using EME?
What are the various types of layout supported by abinitio?
Order of Evaluation of Parameters
What do you understand by a cartesian join?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
how to calculate EME version using unix ?
What are the Types of parallelism in detail?
What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox?
5 Answers JPMorgan Chase, Syntel,
What is the difference between reformat and redefine format?
What is regex (lookup)? When you should use it?
Hi friends, what are the new features in abinito3.0?
What is a data processing cycle and what is its significance?
Teradata 
