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
Netezza Connector - SCD Stage
Moderators: chulett, rschirm, roy
Netezza Connector - SCD Stage
Jim Stewart
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>