DSXchange

I'm trying to use the SCD stage with an ODBC connection, in the most classic way , and the result is that it doesn't update nothing , keep inserting the records.

Can anyone give me any idea where to look for the issue ?

I suppose is another incompatibility between DataStage and Microsoft ..but I need a confirmation before starting to workaround it.

I've had no problems with ODBC Connector/Sql Server/SCD stage in version 11.3.

Have you used the SCD stage before?

I think the first thing to check would be to make sure you don't have the output links backwards. That would probably cause the issue you're seeing.

Then carefully review the purpose codes assigned to each column.

Mike

I've used the Slowly Changing Dimension SCD stage with ODBC before with no ill-effects or strange errors. I would look elsewhere for the cause of your insert issues.

One more question please , did you used all the build-in functionalities of the SCD stage ? like "Auto-generate Upsert SQL" ? Did the stage compare the fields by itself ?
I just noticed that the stage is updating the the SK !