DSXchange

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.

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

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.