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.



Download this Pipeline
  1. Numeric types (INTEGER, BIGINT, DECIMAL, FLOAT)
  2. Character types (CHAR, VARCHAR, CLOB)
  3. Date/Time types (DATE, TIME, TIMESTAMP)
  4. Boolean and BLOB types
  5. Configure the Sequence Snap to generate sequential data to initiate the pipeline flow.
  6. Configure the Mapper Snap to create three SQL statements - an INSERT statement with sample data for various data types, an UPDATE statement to modify character data, and a DELETE statement to remove the inserted record.


  7. Configure the Teradata Multi Execute Snap with the following SQL statements:INSERT: Adds sample records with various data typesUPDATE: Modifies existing records DELETE: Removes records


  8. Validate the Snap. On validation, the Snap receives and validates the three SQL statements from the upstream Mapper:


To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.