slowly changing dimensions

[GSSaru]

hi all,

can u please explain ,how can implement slowlychangingdimensions in a project

[ray.wurlod]

You do exactly what is explained in books such as The Data Warehouse Life Cycle and Toolkit by Kimball et al. You first need to make some decisions, primarily what type of SCD you wish to implement. Then you use appropriate stage types, such as Surrogate Key Generator stage, combined with appropriate logic to manage data loads - both initial and incremental - into dimension and fact tables. On top of this you construct a control hierarchy - probably using job sequences - to ensure that tables are loaded in an order that guarantees the referential integrity is maintained. If you await the next release of DataStage, there is a SCD stage that does a lot of this for you.