You want to configure replication of CREATE TABLE statements from oracle to Teradata, so that
only new table created in your mapped source schema is Replicated. Which should be the part of
solution?
A.
This feature is not supported in oracle goldenGate 10.
B.
DDL INCLUDE MAPPED in extra parameter file.
C.
DDL INCLUDE UNMAPPED in extra parameter file.
D.
DDL EXCLUDE MAPPED in extra parameter file.
Explanation:
DDL INCLUDE MAPPED in extra parameter file. This means that DDL support is now enabled for
all tables which have been mapped
Reference :
http://gjilevski.wordpress.com/2010/02/19/configuring-ddl-synchronization-with-oracle-goldengate/
A. Mapped parameter is used in Replicate parameter file, not in extract one.
Is is not true. The answer is correct, “DDL INCLUDE MAPPED” enables extracting the DDL which ran in the database and you have to configure it on extract
How do I replicat Oracle DDL or Truncate to Teradata (Doc ID 1592682.1)
DDL replication (including Truncate) is only supported on like databases with identical structures.
That means only Oracle to Oracle or Teradata to Teradata.
Oracle to Teradata DDL replication is not currently (10/2013, OGG v12.1.2) supported and there are no plans to support it.
Thanks Ashish…