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.

For example, create a

m_teradata_pdo_crossSchema

Teradata ODBC mapping.

For example, add a Source transformation and include a Teradata source object and connection

teradata_odbc1

to read data using

TERADATA_SCHEMA1

.

For example, add a Target transformation and include a Teradata target object and connection

teradata_odbc2

to write data using

TERADATA_SCHEMA2

.

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.