satyambabu

• Mar 18th, 2006

 

First find out the what records are existing and what records are inserted nad what records are updated.

kareem

• Mar 20th, 2006

 

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.

Rob

• Apr 25th, 2006

 

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

babushiv

 Profile Answers by babushiv Questions by babushiv

• May 24th, 2010

 

The Type 2 Dimension Data mapping inserts both new and changed dimensions into the target. Changes are tracked in the target table by versioning the primary key and creating a version number for each dimension in the table. Use the Type 2 Dimension/Version Data mapping to update a slowly changing dimension table when you want to keep a full history of dimension data in the table. Version numbers and versioned primary keys track the order of changes to each dimension.