Greenplum Connector

Greenplum Connector

Match and update columns

Match and update columns

Before you run a session that loads data to a Greenplum target, you can configure the match and update columns.

Match Columns

You can specify the columns to use as the join condition for the update. The attribute value in the specified target columns must be equal to that of the corresponding source data columns in order for the row to be updated in the target table. You must specify the match columns if the method to process data from the named pipe is update or merge.

Update Columns

You can specify the columns to update for the rows that meet the criteria for match columns and the update column property. Update columns cannot be columns that are used for the Greenplum distribution key for the table. You must specify the match columns if the method to process data from the named pipe is update or merge.
The following table describes the session properties you can configure for match and update columns:
Target Property
Description
Match Column
Matches rows based on the comma-separated list of column names. Enclose the column names in double quotes and ensure that there are no leading and trailing spaces between the column names.
Update Column
Updates the columns specified in the comma-separated list of column names. Enclose the column names in double quotes and ensure that there are no leading and trailing spaces between the column names.

0 COMMENTS

We’d like to hear from you!