Netezza Connector - SCD Stage

[Raftsman]

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

[ArndW]

If you output the SCD stage data to a sequential file (or peek stage, if the volumes are small) and inspect the one key in question are you sure that the Netezza is introducing an error?

Are you using insert/update mode and have you activated use of TWT in the stage? If you are sure of the data coming out of the SCD then you might toggle the TWT setting to see if that makes a difference.