Netezza Connector - SCD Stage
Posted: Wed Sep 02, 2015 9:21 am
Using the SCD stage with Netezza and for some reason the Updates are not working.
Input Table
Key Description
01 Text Type1
01 TextF
When it goes through the SCD, two rows come out but duplicates end up in Netezza. Key is the primary key on the table.
I checked with DBA's and an update was sent to the table. Netezza creates temporary tables prior to loading the physical table. Not sure if this is the issue.
Any info is greatly apprecaited.
Thanks
Input Table
Key Description
01 Text Type1
01 TextF
When it goes through the SCD, two rows come out but duplicates end up in Netezza. Key is the primary key on the table.
I checked with DBA's and an update was sent to the table. Netezza creates temporary tables prior to loading the physical table. Not sure if this is the issue.
Any info is greatly apprecaited.
Thanks