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 |
EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer
what is decoding & what is NVL?
How do we extract data from client machine?
What is a deadlock and how it occurs?
Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is populate file(pid,sid,Adress) I want (cname & total poplation) how i can get the output please help me Thank you
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
What a local lookup is?
What are the types of data processing you are familiar with?
How to move or copy the project parameter or project object to my sandbox?
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
Mention what the difference between “look-up” file and “look is up” in abinitio?
What is the difference between a utility and api in a RUN SQL component