SCD in datastage-how to implement?

karthikgk0705 · Post by **karthikgk0705** » Mon Sep 04, 2006 11:20 pm

Hi all,
I know the basic concepts about Slowly Changing Dimensions.But I get into trouble when I try to put them in real-time in data stage?

Can anyone clearly explain me how to implement SCD in data stage?
(for all three types).

Thank u

ray.wurlod · Post by **ray.wurlod** » Tue Sep 05, 2006 4:45 am

Have you searched the forum? Techniques have been described here before. You can also enrol in the DataStage Best Practices class from IBM.

Xpert · Post by **Xpert** » Tue Sep 05, 2006 7:15 am

hi

For type1, ur update action should be the following one,
update rows and insert rows without clearing
for type2,
inserting new rows without clearing