go to mapping designer in it go for mapping select wizard in it go for slowly changind dimension

here u will find a new window their u need to give the mapping name source table target table and type of scd then if select finish scd 2 mapping is craeted

go to waredesigner and generate the table then validate the mapping in mapping designer save it to repository run the session in workflow manager

later update the source table and re run agian u will find the difference in target table

hope u got it buddy.

1. Determine if the incoming row is 1) a new record 2) an updated record or 3) a record that already exists in the table using two lookup transformations. Split the mapping into 3 seperate flows using a router transformation.

2. If 1) create a pipe that inserts all the rows into the table.

3. If 2) create two pipes from the same source one updating the old record one to insert the new.

Hope this makes sense

Rob