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
- 18570 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 |
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
What is the difference between sandbox and EME?
Explain how you can run a graph infinitely in ab initio?
How can you increase the number of ports of your output flow? What is the limit? Can i have 20 out ports?
Difference between output_index and output_indexes in reformat
What is Is_defined(), Is_null(), Is_Blank()?
Explain the methods to improve the performance of a graph?
What are the Types of parallelism in detail?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
What is the diff between abinitiorc and .abinitiorc files ?
State the first_defined function with an example?
Teradata 
