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
- 18694 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
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
Why do you think data processing is important?
What dedup-component and replicate component does?
What is de-partition in abinitio?
What is a deadlock and how it occurs?
Difference between informatica vs ab initio?
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 do you mean by the term data warehousing?
Mention some file extensions which are used in abinitio?
What are the types of data processing you are familiar with?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What are the factors on which storage of data depends?
Mention what are the different types of parallelism used in abinitio?
Explain about ab initio’s dependency analysis?
What is a rollup component?
