SCD Stage with Type 2

[Souji]

Hi Experts,
I am implementing SCD Stage with Type-2 option. I created a job like this:


Src------LkpStage(with 2Oracle Enterprise stages as reference Tab) and Lkp(1 Oracle Enterprise stage as re) and updateing Bank table as a Target upsert.

I tried to loaded 1000 rows to WH. When I tried to load same rows without truncate table, it is showing 1000+4500.

I implemented Type-2 but I don't think this is doing type 2.

Please excuse me if any grammatical mistakes are there.

Please help me how to implement Type-2

Thanks
Soumya

[ray.wurlod]

That's not how the SCD stage works. This is:

Code: Select all

            Dim1      Dim2
             |         |
             V         V
Source -->  SCD ----> SCD ----> Fact
             |         |
             V         V
            Dim1      Dim2

[mail2krishna79]

Ray,
Thanks for your response.
So if i want to bring 3 tables are lookup before SCD Stage for 1 Dimension, will that work.
I did this way:

table1 table2 table3 Dim


Source------lkp1 ----------lkp2---------lkp3------SCD--------FACT



Dim

Ray, do you think this will work?. Please advise

Thanks
Soumaya

[ray.wurlod]

No. Each SCD stage requires two inputs and two outputs.