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.



  1. Select the table, Book under the schema, TECTONIC, using the Oracle Select Snap.


  2. The Mapper Snap maps the incoming data from Oracle to the Teradata Table. Note that the source and the target column data types should match for the data to load successfully.


  3. The data is loaded to the table book123 under the schema, Snaplogic.


  4. Successful execution of the pipeline displays the below output preview:Note that the preview displays the insert count as 2 and the duplicate count as 48 out of the 50 records that are read.


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.