Regarding SCD stage in Datastage 8.0

janakiram_ccr · Post by **janakiram_ccr** » Mon Oct 15, 2007 4:36 am

Hi,

I am very new to Datastage and i am using the version 8.0.

I need to implement a mapping with SCD-type2 logic. Just saw a stage called SCD, so need to know how to use this stage.

Thanks,
Janakiram.C

ArndW · Post by **ArndW** » Wed Oct 17, 2007 1:02 am

Hello and welcome to DSXchange, Janakiram.

If you browse the forums you will see that this site is a good place to get specific questions or problems answered but a bad one to get sample jobs and general explanations. The SCD stage is documented, at least in enough detail to experiment writing a job that uses it. Once you have done that and have encountered a particular problem that you need assistance on you can post that question and you will surely get a very quick and detailed response from one or more of the knowledgeable people in this forum; but your question as it stands right now will not be answered.

ArndW · Post by **ArndW** » Wed Oct 17, 2007 1:03 am

Hello and welcome to DSXchange, Janakiram.

If you browse the forums you will see that this site is a good place to get specific questions or problems answered but a bad one to get sample jobs and general explanations. The SCD stage is documented, at least in enough detail to experiment writing a job that uses it. Once you have done that and have encountered a particular problem that you need assistance on you can post that question and you will surely get a very quick and detailed response from one or more of the knowledgeable people in this forum; but your question as it stands right now will not be answered.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 17, 2007 9:42 am

Vincent has a blog on this stage type. Essentially you use one SCD stage for each dimension table, and the result is destined for the fact table. Within the SCD stage you specify for each field whether it is to be handled as Type 1 or Type 2.

The stage manages an in-memory image of the dimension table, and keeps it up to date as the job progresses. A typical job design might look like the following:

Code: Select all

         Dimension1     Dimension2     Dimension3
                |           |           |
                V           V           V
Source -----> SCD1 -----> SCD2 -----> SCD3  ---->  FactTable
                |           |           |
                V           V           V
         Dimension1     Dimension2     Dimension3

ray.wurlod · Post by **ray.wurlod** » Wed Oct 17, 2007 9:43 am

Vincent has a blog on this stage type. Essentially you use one SCD stage for each dimension table, and the result is destined for the fact table. Within the SCD stage you specify for each field whether it is to be handled as Type 1 or Type 2.

The stage manages an in-memory image of the dimension table, and keeps it up to date as the job progresses. A typical job design might look like the following:

Code: Select all

         Dimension1     Dimension2     Dimension3
                |           |           |
                V           V           V
Source -----> SCD1 -----> SCD2 -----> SCD3  ---->  FactTable
                |           |           |
                V           V           V
         Dimension1     Dimension2     Dimension3