When performing a partial copy using XML, embed a <sql_where_clause> tag and one or more <key_column> tags within the table tag of the table where the partial copy should be performed. The <sql_where_clause> tag specifies the SQL WHERE clause used for the extract side of the partial copy job. The <key_column> tag is used to specify the name of the columns that uniquely identify each row when upserting them into the target table.
For example:
<table selection="included"> <name>Table1</name> <sql_where_clause><![CDATA[ WHERE col1 > 4]]></sql_where_clause> <key_columns> <key_column>col1</key_column> <key_column>col2</key_column> </key_columns> </table>
Inside the <sql_where_clause> tag, the WHERE clause must be surrounded by the special CDATA tag, <![CDATA[ where clause ]]>, and the WHERE clause must include the WHERE keyword. Do not use a ; character at the end of the SQL.
For optimal results, if at least one of the primary indexes is unique, specify all primary indexes as key columns. For PPI tables, specify all primary indexes and the partitioned columns as key columns. Omitting the partitioned columns when specifying primary indexes can result in job failure.