This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.

Teradata PT uses and expands on the functionality of the traditional Teradata extract and load utilies, that is, FastLoad, MultiLoad, FastExport, and Tpump.

Teradata PT supports:

  • Process-specific operators: Teradata PT jobs are run using operators. These are discrete object-oriented modules that perform specific extraction, loading, and updating processes.
  • Access modules: These are software modules that give Teradata PT access to various data stores.
  • A parallel execution structure: Teradata PT can simultaneously load data from multiple and dissimilar data sources into, and extract data from, Teradata Database. In addition, Teradata PT can execute multiple instances of an operator to run multiple and concurrent loads and extracts and perform inline updating of data. Teradata PT maximizes throughput performance through scalability and parallelism.
  • The use of data streams: Teradata PT distributes data into data streams shared with multiple instances of operators to scale up data parallelism. Data streaming eliminates the need for intermediate data storage: data is streamed through the process without being written to disk.
  • A single SQL-like scripting language: Unlike the traditional standalone utilities that each use their own scripting language, Teradata PT uses a single script language to specify extraction, loading, and updating operations.
  • An application programming interface (API): Teradata PT can be invoked with scripts or with the Teradata PT set of open APIs. Using the Teradata PT open APIs allows third-party applications to execute Teradata PT operators directly. This makes Teradata PT extensible.
tt255009 4 comments Joined 11/12
30 May 2013

I am trying to load data with TPT Load Operator. I have the following parameter values
1.       ErrorLIMIT1 = 5
2.       ErrorLIMIT2 = 5
3.       Maxsessions = 1
4.       Minsessions = 1
5.       Loader_Instance = 1
I have a file with 10 UV Values for a single Key value e.g., for primary key = 2 there are 10 UV records. I expected TPT to fail but it did not. Can anyone explain this behavior? What is the scenario in which Errorlimit is used by TPT and it fails?

You must sign in to leave a comment.