Create Target Table
This function creates a new table at destination database when no target table is
available for the copy job. The new table created can propagate constraints which
include CHECK, UNIQUE KEY and PRIMARY KEY with the exception of FOREIGN KEY.
For a export jobs, the OLE DB Access Module tries to create a target table with constraints.
If this method fails, the OLE DB Access Module tries to create a target table without
constraints. If both methods fail to create the target table, then consider creating
the target table manually before performing the copy operation.
For a import jobs, the OLE DB Access Module creates a CREATE TABLE statement that
obtains constraint information from the source database. If the module fails to retrieve
the constraint information, a CREATE statement is prepared and available in the script
generated for load jobs. Review the CREATE statement in the script before submitting
the job. Another option is to create a target table before executing such jobs.
Note: A load job might fail to copy data from a non‑Teradata Database to Teradata Database
because of utility or PT operator restrictions. For example, the Multiload/PT Load
operator cannot load a target table with a secondary index. In these cases, consider
editing the script before submitting the job.