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
Can sorting and storing be done through single software or you need different for these approaches?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
What are the functions of the replicate and dedup component?
How do you add default rules in the transformer?
What exactly do you understand with the term data processing and businesses can trust this approach?
Explain PDL with an example?
What is m_dump?
Explain the methods to improve performance of a graph?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
What is the syntax for m_dump in abinitio?
How you can run a graph infinitely in ab initio?
What is the function you would use to transfer a string into a decimal?
Mention what is a partition and what are the different types of partition components in abinitio?
What are the different types of parallelism in ab initio?
How do you add default rules in transformer?
