Copying Partial Tables - Teradata Data Mover

Teradata Data Mover User Guide

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

You can copy partial data from one or more Partitioned Primary Index (PPI) table when you copy an entire database using ARC.

If you specify a table that does not exist on the target, the table is created and partial data copied to the table.

An error results if you try to copy partial data from a non-PPI table when copying the entire database.

When copying an entire database, if a table specified as "included" is not being renamed, relocated, or partially copied, the specified table element is ignored.
  1. Open the parameters.xml file that has the job definition information for the job.
  2. Under the database name, add the selection="included" attribute to the table element.
  3. Add the <name> element and specify the table name.
  4. Add a <sql_where_clause> element and specify the WHERE restriction.
  5. Add a <key_columns> element and specify the column of the partial data.
In the following example, partial data from the orderdate column of the DBName.PPIOrders table is copied to the target DBName.PPIOrders table.
<database selection= "included">
	<name>DBName</name>
		<table selection="included">
			<name>PPIOrders</name>
			<sql_where_clause>
				<![CDATA[WHERE orderdate IN (select orderdate from "DBName"."PPIOrders")]]>
			</sql_where_clause>
			 <key_columns>
				  <key_column>orderdate</key_column>
			   <key_column>orderkey</key_column>
				</key_columns>
		</table>
</database>