Page 1 of 1
Regarding SCD stage in Datastage 8.0
Posted: Mon Oct 15, 2007 4:36 am
by janakiram_ccr
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
Posted: Wed Oct 17, 2007 1:02 am
by ArndW
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.
Posted: Wed Oct 17, 2007 1:03 am
by ArndW
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.
Posted: Wed Oct 17, 2007 9:42 am
by ray.wurlod
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
Posted: Wed Oct 17, 2007 9:43 am
by ray.wurlod
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