The Applier task can apply the following DDL operations to Teradata targets:
ALTER TABLE
table_name
ADD
column_name
datatype
[NULL|NOT NULL]
ALTER TABLE
table_name
ADD CONSTRAINT
constraint_name
UNIQUE (
column_name
)
ALTER TABLE
table_name
DROP CONSTRAINT
constraint_name
CREATE TABLE
table_name
(
column_name
datatype
[NULL|NOT NULL]) PRIMARY INDEX (
column_name
)
CREATE UNIQUE INDEX
index_name
(
column_name
) ON
table_name
DROP INDEX
index_name
ON
table_name
DROP TABLE
table_name
Data Replication does not replicate ALTER TABLE operations that modify a source column datatype to Teradata targets because Teradata does not support these types of DDL operations. Data Replication can only replicate operations that increase the length of character columns.
Data Replication does not replicate DROP COLUMN operations for the source columns that are part of the primary key. For source tables that do not have a primary key, Data Replication does not replicate DROP COLUMN operations for the first column.
Data Replication replicates TRUNCATE operations from sources to Teradata targets as DELETE ALL operations.