The Teradata Connector stage in DataStage allows to read and write records to the Teradata tables. The Teradata Connector stage has many capabilities and Better than earlier Teradata stages.
Teradata API, Teradata Enterprise, Teradata Load and Teradata Multiload stages are depreciated, and the developer must migrate to Teradata connector stage using Connection migration tool.
For Immediate operations such as read, lookup and write, the Teradata connector stage uses CLIv2 interface and TPT Direct API for Bulk operations (the connector utilizes the operators in the TPT for Teradata FastExport, FastLoad and MultiLoad operations.
- 1 Teradata Connector properties:
- 2 Advanced configuration:
- 2.1 Array size
- 2.2 Error limit
- 2.3 Error table 1
- 2.4 Error table 2
- 2.5 Fail on error
- 2.6 Fail on size mismatch
- 2.7 File
- 2.8 Max buffer size
- 2.9 Parallel synchronization
- 2.10 Avoiding deadlocks
- 2.11 Configuring the connector to perform lookups (Sparse Lookup)
- 2.12 Teradata connector Stage in Datastage
- 2.13 Related
Teradata Connector properties:
Mostly used properties:
|Server:||Source/Target Server Ip or name|
|Write mode :||Insert ,update ,delete ,insert the update,update then insert and delete then insert|
|Generate SQL||Source /target table name|
|Access Method:||Immediate /bulk|
|Table Name:||if yes then stage will automatically generate it at runtime|
Configuring the Teradata connector as a source
- Go to the Properties tab, set the connection properties such as server IP, database, username, table name and password for the Teradata database.
- You could specify the select SQL statement or set the generate SQL at runtime to Yes
Configuring the Teradata connector as a target
- Go to the Properties tab, set the connection properties such as server IP, database, username and password for the Teradata database.
- Specify the table name of the target table.
- Set the access method as Immediate or bulk.
configure the array size in Teradata connector to define the maximum number of rows to transfer in each read or write operation.
Set the error threshold to define the maximum number of rows that can be rejected to the first error table.
Error table 1
To set the name of the first error table for the bulk load.
Error table 2
To set the name of the second error table for the bulk load.
Fail on error
Use this property to specify whether to terminate the job or continue processing if
the SQL statement in the parent property fails.
Fail on size mismatch
Specify whether a job fails if the sizes of numeric and string mismatches.
specify the name of a file that contains the SQL statements to run for each input row.
Max buffer size
To set the maximum buffer size
Use this property to specify whether to synchronize parallel reads or writes by using a synchronization table.
If multiple updates for a row are not from the same connection, deadlocks might occur while performing immediate writes in parallel mode
To solve this, you must set a partitioning method to ensure that update comes from the same partition.
Configuring the connector to perform lookups (Sparse Lookup)
Go to the Properties tab, set the sparse lookup method in Lookup type field.