Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anonymous
we can implement scd2 using the below scenario in abinitio:-
1. take 2 tables as your input first would be your today's file that is in0 second be your previous file that would be in1.
2. take the inner join of both the tables on the matching key say cust_id, and in the out port of the dml make it embedded and do the naming convention by adding the suffix _new for the today's file and _old for the prev day file data records so to make it easier to understand the data fields.
3. In the join components, unused 0 will give you inserted records(that would come from today's file), and unused 1(that would come from yesterday's file) will give you deleted records.
4. take a reformat connecting the join output port and check:
if ( _new != _old) (these are the suffix we have given in the dml output port coming from the join component), force error it from the reject port of reformat those will be your updated records and you will get the unchanged records from the output port of reformat.
5. combine all the inserted records from join unused 0, updated records from reject port of reformat and unchanged records from out port of reformat and load all of them into the delta table.
this would complete the scd type 2 execution in abinitio.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is data encoding?
Explain the ab initio etl tool in high level?
Describe in detail about lookup?
what is the difference between i)public ii)private iii)common and client projects?
What metadata importer can do in ab initio?
what is the project environment(for each project the environment is same or different to different project)?
What do you mean by the overflow errors?
What will be the skew for, input file->partition by key-> partition by round robin->output file
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
How transaction file different from that of a sort file?
Explain how you can run a graph infinitely in ab initio?
What is the ab initio business rules environment (bre)?
What is the role of co-operating system in abinitio?
What is data mapping and data modelling?
What are the kinds of layouts does ab initio supports?
