Can any body give me the clear explanation about how to
separate header,trailer and body records in Ab Initio?
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 |
How will you check the latest versions in EME?
. How can you get all the fields form a lookup files ? (Which function)
what is the difference between the .dbc and .cfg extensions and give any clear information ?
How to create a repository in abinitio for stand-alone system(local nt)?
what is the difference between ab_work_dir and .work
What is Is_defined(), Is_null(), Is_Blank()?
State the first_defined function with an example?
What do you mean by the term data warehousing?
How to run the graph without GDE?
What is local and formal parameter?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa