About Performing Partial Copies - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

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.