Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Teradata Parallel Transporter API
  3. PowerExchange for Teradata Parallel Transporter API Configuration
  4. PowerExchange for Teradata Parallel Transporter Connections
  5. PowerExchange for Teradata Parallel Transporter API Data Objects
  6. PowerExchange for Teradata Parallel Transporter API Mappings
  7. Teradata Parallel Transporter API Run-time Processing
  8. Data Type Reference

PowerExchange for Teradata Parallel Transporter API User Guide

PowerExchange for Teradata Parallel Transporter API User Guide

Teradata Mapping Example

Teradata Mapping Example

Your organization, ABC Airlines, needs to analyze flight information from the log files that are generated for each flight to find the number of flights to a particular destination in a month. Create a mapping that reads the flight log information of all the flights and writes specific information to Teradata tables.
You can use the following objects in a Teradata mapping:
Mapping input
The mapping source is a table in an Oracle database or a flat file that contains the flight log information of ABC Airlines.
Import the Oracle or flat file data object with the flight log information. Create a data object read operation for the Oracle data object you have created. Add the data object read operation to the mapping.
Transformation
Use the Filter transformation to specify the month and destination.
Mapping output
The mapping output is a data object write operation to load the data to a Teradata table. Run the mapping either in the native or Hadoop environment.
When you run the mapping, the Data Integration Services writes the extracted information about the number of flights in a month to a specific destination to the Teradata target table. You can then use the information for data analysis.


Updated October 05, 2018