how to prepare scd2 in abinitio
Answer / 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 |
What is sort component in abinitio?
What does dependency analysis mean in Ab Initio?
Hi friends, I have 100 records in my input file, if i run first,the first 10 records are stored into the output and if i run second time next 10 records stored into the output file like that please let me know the answer Thanks, krishna
What do you mean by the term data warehousing? Is it different from data mining?
What is the difference between partitioning with key and round robin?
What is a deadlock and how it occurs?
How can a graph be run infinitely?
If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?
What is abinitio?
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
Need Ab-Initio Material - Harini
what are kinds of layouts does ab initio supports ?