ramoojobs

 Profile Answers by ramoojobs 

• Apr 20th, 2006

 

We can handle SCD in the following ways

            Type 1: Just use, ?Insert rows Else Update rows?

                        Or

                        ?Update rows Else Insert rows?, in update action of target

Type 2: Use the steps as follows

a)     U have use one hash file to Look-Up the target

b)     Take 3 instances of target

c)     Give different conditions depending on the process

d)     Give different update actions in target

e)     Use system variables like Sysdate and Null.

 

Sivarao

• May 15th, 2006

 

to develope scd type 2 us the update action in target as " insert new rows only"

for this u need to maintain primary key as composite key in target table . it would be better to use timestamp column as one of key column in target table.