SCD stage Type 2

tayebir · Post by **tayebir** » Thu Nov 06, 2008 10:48 am

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.

Vinodanand · Post by **Vinodanand** » Thu Nov 06, 2008 11:00 am

Hi,
Can you provide more information about your job design .
Regards,
Vinod

tayebir · Post by **tayebir** » Thu Nov 06, 2008 11:15 am

Vinodanand wrote:Hi,
Can you provide more information about your job design .
Regards,
Vinod

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.
I hope this is sufficient.

Thanks.