How to change value of a column in destination table based on Insert/Update

[Anonymous]

Hi,

It would be very helpful if someone could help me out.

I have a column "Active Flag" with value "A" in the source table and a column "Change Type" in my destination table and need to store values in "Change Type" column as-

1) When "Active Flag" is "A" =>

     a) If data is inserted for the first time then store "I" in Change Type column

     b) If it is data change is detected i.e. data has been updated then change value of Change Type column to "U"

2) When "Active Flag" is "I" =>

    a) Store "D" in Change Type Column.

Thanks in Advance.

[akumar2301]

Looks like , you need to do SCD2 implementation using tMap.