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 Teradata Access Module for OLE DB tries to create a target table with constraints. If this method fails, the Teradata Access Module for OLE DB 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 Teradata Access Module for OLE DB 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.
A load job might fail to copy data into a 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.