IIS-CONN-NZ-01033W
The following distribution-key column(s): column_name from the table table_name were not found in the input link schema. The temporary work table will use the random distribution

Explanation

When the connector creates a temporary work table (TWT), the connector tries to replicate the distribution mechanism of the target table. This message is logged when the target table uses hash distribution to organize the database table, and one or more distribution key columns are missing from the link. Because the connector cannot use hash distribution, the connector uses random distribution for the TWT that it creates.

User response

(Optional) If you want the TWT to match the distribution of the target table, make sure all distribution key columns are present on the link and that their data types match the data types of the columns in the target table.
Parent topic: Netezza connector messages