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.
Slowly Changing Dimension stage update issue
Moderators: chulett, rschirm, roy
Slowly Changing Dimension stage update issue
Thanks,
Emma
Emma
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
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>