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.

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

0 Answers  

---

I wanted to learn Ab Initio, Could you please send the material to my personal email id.

2 Answers  

---

Layout - L1*, L1 - What is the difference

3 Answers  

---

What are the functions of the replicate and dedup component?

0 Answers  

---

How will you use EME for view or publish metadata reports using EME?

1 Answers  

---

What is the latest version that is available in Ab-initio?

14 Answers   TetraSoft,

---

How can I run the 2 gui merge files?

0 Answers  

---

How to add default rules in the transformer?

0 Answers  

---

what is the difference between i)public ii)private iii)common and client projects?

0 Answers  

---

How does the bre work with the co>operating system?

0 Answers  

---

How you can test a dbc file ?

1 Answers   TCL,

---

How to load the data from an excel sheet to input file in a graph?

2 Answers   IBM,

---