Configuring cross-schema SQL ELT optimization for a Teradata ODBC mapping
You can use cross-schema SQL ELT optimization for a mapping to read or write data based on different schemas within the same database.
To configure cross-schema SQL ELT optimization for a Teradata ODBC mapping task, perform the following steps:
1Create Teradata ODBC source and target connections, each defined with a different schema.
For example,
- Create a teradata_odbc1 Teradata ODBC connection and specify the TERADATA_SCHEMA1 schema in the connection properties.
- Create a teradata_odbc2 Teradata ODBC connection and specify the TERADATA_SCHEMA2 schema in the connection properties.
2Create a Teradata ODBC mapping.
For example, create a m_teradata_pdo_crossSchema Teradata ODBC mapping.
3Add a Source transformation and include a Teradata object and connection to read data using the schema specified in the connection.
For example, add a Source transformation and include a Teradata source object and connection teradata_odbc1 to read data using TERADATA_SCHEMA1.
4Add a Target transformation and include a Teradata target object and connection to write data using the schema specified in the connection.
For example, add a Target transformation and include a Teradata target object and connection teradata_odbc2 to write data using TERADATA_SCHEMA2.
5Create a Teradata ODBC mapping task, and perform the following tasks:
aSelect the configured Teradata ODBC mapping.
For example, select the m_teradata_pdo_crossSchema Teradata ODBC mapping.
bIn the SQL ELT Optimization section on the Runtime Options tab, set the SQL ELT optimization value to Full.
cIn the Advanced Session Properties section, select the Enable cross-schema SQL ELT optimization check box.
dSave the task, and click Finish.
When you run the mapping task, the Secure Agent reads data from the Teradata source object associated with the TERADATA_SCHEMA1 schema and writes data to the Teradata target object associated with the TERADATA_SCHEMA2 schema.