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
- 18704 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 can you get all the fields form a lookup files ? (Which function)
What is the difference between partitioning with key / hash and round robin?
What are the different String functions used in Abinitio?
What is the best way of creating huge test feeds ? How to use in abinitio graph?
Mention what is the role of co-operating system in abinitio?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What is the difference between sandbox and EME?
Describe step by step the process of creating tag and savefile for migration
What is max core value ? what is the use of it?
2 Answers JPMorgan Chase, Wipro,
What does it mean by the term 'sort component'?
Do you know what a local lookup is?
Teradata 
