About DDL Comparison - 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

The DDL comparison feature compares the DDL of the source table or view columns with the DDL of the target table or columns prior to copying the table or view. If the table does not already exist on the target system, the comparison is skipped.

When the feature is enabled, the comparison takes place every time the create or move command is used to create a job, or the start command is used to start a job.

DDL Comparison for Tables

DDL comparison for a table compares the number of columns and the following values for each column:
  • Name
  • Type
  • Length
  • Character type
  • Constraint
  • Constraint count
  • UDT name
  • Compressible
  • Default value
  • Format
  • Identity column type
  • Nullable
  • Stored procedure parameter type
  • Upper case flag
  • Decimal fraction digits
  • Decimal total digits

If any of these values are not the same for the source and target tables, the job fails.

DDL Comparison for Views

DDL comparison for a view compares the columns of the source view with the columns of the source table. It does not compare the definitions of the source and target views. To compare DDL when copying data from a view, the copyData attribute for the view must be set as true.

Scope Levels and Priority Logic

The following table shows the objects included at each scope level, and the priority logic applied if you specify different values at the scope levels. If you set the DDL comparison flag at more than one scope level, the smallest scope has the highest priority. For example, if you set the <compare_ddl> element to true at the database level but false at the job level, DDL comparison for all of the tables and views in the specified database is performed.
Scope Level Objects Compared Priority
Object The specified table or view Highest
Database All tables and views in the specified database Higher
Job All tables and views in the job High
Daemon All tables and views processed by a specific daemon Low
If none of the values for the scope levels above are specified, the default logic applies:
Objects Copied Default Logic
Individual tables and views True. DDL comparison is performed.
An entire database False. DDL comparison is not performed.