Hi all
plz give me some brief information about scd stage and mainly i want to know about expiration date and output links
scd stage
Moderators: chulett, rschirm, roy
The SCD stage reads source data on the input link, performs a dimension table
lookup on the reference link, and writes data on the output link. The output link
can pass data to another SCD stage, to a different type of processing stage, or to
a fact table. The dimension update link is a separate output link that carries
changes for the dimension. You can perform these steps in a single job or a
series of jobs, depending on the number of dimensions in your database and
your performance requirements.
SCD stages support both SCD Type 1 and SCD Type 2 processing as follows:
SCD Type 1
Overwrites an attribute in a dimension table.
SCD Type 2
Updates the existing row to indicate it expired and adds a new row to the
dimension table.
Please Refer to the Documentation, you will find more info. there
lookup on the reference link, and writes data on the output link. The output link
can pass data to another SCD stage, to a different type of processing stage, or to
a fact table. The dimension update link is a separate output link that carries
changes for the dimension. You can perform these steps in a single job or a
series of jobs, depending on the number of dimensions in your database and
your performance requirements.
SCD stages support both SCD Type 1 and SCD Type 2 processing as follows:
SCD Type 1
Overwrites an attribute in a dimension table.
SCD Type 2
Updates the existing row to indicate it expired and adds a new row to the
dimension table.
Please Refer to the Documentation, you will find more info. there
Thanks,
Mohan.A.Jasti.
Mohan.A.Jasti.
Try this ...
You have 2 output links from SCD stage.One is for inserts(say link1) and the second is for Updates(link2).You can design the job to have two instances of target table one is for inserts and the second is for updates. Connect link 1 to targettable(insert) via a surrogatekeygen. stage(if required). and connect link2 to targettable(update).. and provide the proper insert and update sqls.
I am not sure as I have never worked on the SCD stage
You have 2 output links from SCD stage.One is for inserts(say link1) and the second is for Updates(link2).You can design the job to have two instances of target table one is for inserts and the second is for updates. Connect link 1 to targettable(insert) via a surrogatekeygen. stage(if required). and connect link2 to targettable(update).. and provide the proper insert and update sqls.
You need to use surrogate key in the where clause of the update satement...I guess..it give 2 o/p links one contains updated data and other contains source data or inserted data and one more thing is iam getting in dim_update surrogate key as 34,41,56,.... plz help
I am not sure as I have never worked on the SCD stage
Thanks,
Mohan.A.Jasti.
Mohan.A.Jasti.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For one dimension table:
Code: Select all
DimTable
|
|
V
----> SCDStage ----> FactTable
|
|
V
DimTable
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.