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
- 18796 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 |
Describe the evaluation of parameters order in ab initio?
What are the factors on which storage of data depends?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
what is different daily and monthly develop the abinitio graphs?
Explain the methods to improve performance of a graph?
What is ab initio enterprise meta>environment (eme)?
What are the various types of layout supported by abinitio?
How many parallelisms are in Abinitio?
Can anyone give me an exaple of realtime start script in the graph?
Output for sort and dedupsort with NULL key?
State the first_defined function with an example?
What are the different types of partition components in abinitio?
Teradata 
