TPT Delete example

In this pipeline, the TPT Delete Snap deletes the TPT table items by providing a delete query condition.

• TPT Delete

TPT FastExport example

In this example, the pipeline exports the data from a table to a flat file using the TPT FastExport Snap. The data thus exported is read and parsed to an output view using the File Reader and the CSV Parser Snaps.

• TPT FastExport

TPT Insert example

In this pipeline, the TPT Insert Snap inserts the records on the TPT table via the upstream JSON Generator Snap.

• TPT Insert

TPT Load example

This pipeline passes values into a table on TPT and writes the records to an output view.

• TPT Load

TPT Update example

In this pipeline, the TPT Update Snap updates the values in the records of the TPT table using the upstream JSON Generator Snap. The error view is enabled for the invalid records to be routed to the error view.

• TPT Update

TPT Upsert example

The Mapper Snap connected to the input view of the TPT Upsert Snap, maps the values to be updated or inserted to the respective columns of the table.

• TPT Upsert

TPT Upsert update existing records

The TPT Upsert Snap updates and/or inserts the upstream values on the records of the target table Insert Sample3 under the schema ADW SNAPL.

• TPT Upsert

Teradata Execute example

This example demonstrates how to execute various commands using the Teradata Execute Snap.

• Teradata Execute

Teradata Export to HDFS example

In this example pipeline, the Teradata Export to HDFS Snap executes a SQL query and publishes the results to an HDFS directory.

• Teradata Export to HDFS

Teradata FastLoad example

In this example, we shall load records from an Oracle database using the Oracle Select Snap, to a Teradata table using the Teradata FastLoad Snap.

• Teradata FastLoad

Teradata Multi-Execute Operations

The following example pipeline demonstrates the functionality of the Teradata Multi Execute Snap by performing database operations on the target table with the following data types.

• Teradata Multi Execute
• Mapper
• Sequence

Teradata Select example

This example demonstrates using the Teradata Select Snap to query data from a Teradata database.

• Teradata Select