Working With Staging Databases - 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

Work with staging databases by specifying staging at the database and target levels, staging and target at the job and system levels, and a secondary staging database.

Staging tables are created as NOPI tables unless TPTAPI_UPDATE is being used to load data to the staging table. TPTAPI_UPDATE does not support loading to a NOPI staging table. In this case, the staging table is created with the same Primary Index as the source table.