IIS-CONN-GP-01030W In the input link schema, the following distribution key columns from the table_name table were not found: column_name. The temporary table will use a random distribution.
Explanation
When the connector creates a staging table, the connector
tries to use the same distribution mechanism as the target table.
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 staging table that it creates.
User response
To suppress the warning message, make sure that
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
so that the distribution of the staging table matches the distribution
of the target table.