DSXchange

Can anyone explain about how slowly changing dimensions are implemented in the DW design. And how to implement surrogate keys in real time scenario

Pavan,

Take a look in the sdk/KeyMgt folder of Server Routines, there are some routines there that can help with surrogate key allocation.

As for SCD's, depends on whether you want Type 1,2, or 3. If you search this forum you'll find the subject is fairly well covered.

In short, DataStage (Server) does not do the work for you. You have to join the incoming data stream to the existing table, compare each column to see if it has changed using Stage Variables, and use multiple output links to insert/update the target table.

If you are implementing a type 2 SCD, you need to be careful with your Array Size and Transaction Size setting on your database plugin stages. Once again, use the search facility in this forum to find ample information.

Search

You are not the first to ask this. Many words of wisdom have been posted. All you have to do is to find them!