Table of Contents

Search

  1. Preface
  2. Introduction to PostgreSQL Connector
  3. Connections for PostgreSQL
  4. Mappings and mapping tasks with PostgreSQL Connector
  5. PostgreSQL objects in mapping tasks
  6. Lookup transformation
  7. SQL transformation
  8. Migrating a mapping
  9. PostgreSQL SQL ELT optimization
  10. Data type reference

PostgreSQL Connector

PostgreSQL Connector

Mappings and mapping tasks with PostgreSQL Connector

Mappings and
mapping
tasks with PostgreSQL Connector

Use the
Data Integration
Mapping Designer to create a mapping. When you create a mapping, configure a Source
or Target
transformation to represent a PostgreSQL object.
In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.
Describe the flow of data from source and target along with the required transformations before the agent writes data to the target. When you create a
mapping
task, select the mapping that you want to use. Use the
Mapping
Task wizard to create a
mapping
task. Validate and run the mapping to read data from sources and write to a target. The
mapping
task processes data based on the data flow logic you define in the mapping.
When you configure a mapping, you can parameterize the source object and the PostgreSQL connection.

0 COMMENTS

We’d like to hear from you!