Hello,
I am having hard time implementing SCD Type 2 using SCD stage in version 8.0.1. I was able to update the Dimension rows using Type 1. For type 2 columns, the rows are updated and new rows are inserted, however the newe rows contain no data (empty fields), can anyone help me with this.
Thanks.
SCD stage Type 2
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 112
- Joined: Mon Jul 11, 2005 7:54 am
I have ODBC stage as lookup reference and Sequntial file Stage for the input, I am sending the Dimension updates to an ODBC stage (same table as in reference lookup) and the output to a Dataset stage.Vinodanand wrote:Hi,
Can you provide more information about your job design .
Regards,
Vinod
I hope this is sufficient.
Thanks.