Preface
Introduction to PowerExchange for PostgreSQL
- PowerExchange for PostgreSQL Overview
PowerExchange for PostgreSQL Configuration
PostgreSQL Sources and Targets
- PostgreSQL Sources and Targets Overview
- Import PostgreSQL Source and Target Definitions
PostgreSQL Mappings
- PostgreSQL Mappings Overview
  - Source Filter
    - Configuring a Source Filter
  - Source Join
    - Configuring a Source Join
- PostgreSQL Mapping Example
PostgreSQL Sessions
PostgreSQL Pushdown Optimization
PostgreSQL Data Type Reference
- Data Type Reference Overview
- PostgreSQL and Transformation Data Types

PowerExchange for PostgreSQL User Guide for PowerCenter

10.5.4
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.2
- 10.5
- 10.4.0

Back Next

PostgreSQL Mappings Overview

After you import a PostgreSQL source or target definition into the PowerCenter repository, you can create a mapping to extract data from a PostgreSQL source or load data to a PostgreSQL target.

You can extract data from one or more PostgreSQL sources, and load data to one or more PostgreSQL targets. You can join multiple PostgreSQL tables when you specify a join condition.

You can enter a filter condition to reduce the number of source rows the PowerCenter Integration Service returns from PostgreSQL sources. You can enter a single filter condition or a series of conditions.

PostgreSQL Mappings

Source Filter

Source Join

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal