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
- 18788 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 |
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
What is rollup component?
How to implement the funtionality in the custom component to use in the graph?
Layout - L1*, L1 - What is the difference
How to add default rules in transformer?
What is air-project parameter ? How to use in abinitio graph?
3 Answers IBM, TCL, Tech Mahindra,
Code check-in and check-out commands in AbInitio
What is use of creating a save files? How to use in abinitio graph?
1 Answers Cognizant, IBM, Intellego, TCL,
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
what is the syntax of m_dump command?
What is the difference between sandbox and EME?
If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?
Teradata 
