Friday 20 September 2013

1.2 TPT Operators and Compatiblities

TPT operators and Existing Utility Equivalents:

Following Table shows TPT operators and Utility equivalents:

Teradata PT Operator
Utility Equivalent
Purpose
DataConnector operator
Data Connector (PIOM)
Reads data from and writes data to flat files
DataConnector operator with
WebSphere MQ©
Access Module
Data Connector (PIOM)
Reads data from IBM WebSphere MQ
DataConnector operator with
Named Pipes Access Module
Data Connector (PIOM)
Reads data from a named pipe
DDL operator
BTEQ
Executes DDL, DCL, and self-contained
DML SQL statements
Export operator
FastExport
Exports data from Teradata Database
(high-volume export)
Load operator
FastLoad
Loads an empty table (high-volume load)
ODBC operator
OLE DB Access
Module
Exports data from any non-Teradata
Database that has an ODBC driver
OS Command operator
Client host operating
System
Executes host operating system commands
SQL Inserter operator
BTEQ
Inserts data into a Teradata table using
SQL protocol
SQL Selector operator
BTEQ
Selects data from a Teradata table using
SQL protocol
Stream operator
Tpump
Continuously loads Teradata tables using
SQL protocol
Update operator
MultiLoad
Updates, inserts, and deletes rows
FastExport OUTMOD
Adapter operator
FastExport
OUTMOD Routine
Preprocesses exported data with a
FastExport OUTMOD routine before
writing the data to a file
FastLoad INMOD Adapter
Operator
FastLoad INMOD
Routine
Reads and preprocesses data from a
FastLoad INMOD data source
MultiLoad INMOD Adapter
Operator
MultiLoad INMOD
Routine
Reads and preprocesses data from a
MultiLoad INMOD data source



Teradata Parallel Transporter Compatibilities:

  1. Scripts written for Teradata Warehouse Builder Does work with Teradata PT without modification. But new modifications in TPT cannot be applied.

  1. Scripts written for Teradata Stand Alone utilities are not compatible with TPT. They need to be rewritten.


No comments:

Post a Comment