Can any body give me the clear explanation about how to
separate header,trailer and body records in Ab Initio?
Answer Posted / 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 |
Post New Answer View All Answers
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
How can you export a component’s internal parameters ?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Can anyone give me an example of realtime start script in the graph?
What do you mean by the term data warehousing? Is it different from data mining?
Explain what is sort component in abinitio?
What dedup-component and replicate component does?
What is local and formal parameter?
What do you know about partition and also tell us about partition components in abinitio?
You can ask about different vector functions. How to use in abinitio graph?
What are the different types of parallelism in ab initio?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
How transaction file different from that of a sort file?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
Explain what is de-partition in abinitio?