Preface
Introduction to PostgreSQL Connector
- PostgreSQL Connector assets
Connections for PostgreSQL
Mappings and mapping tasks with PostgreSQL Connector
PostgreSQL objects in mapping tasks
Lookup transformation
- Rules and guidelines for uncached lookups
SQL transformation
- Rules and guidelines for SQL transformations
Migrating a mapping
- Use the same object path for the migrated mapping
- Use a different object path for the migrated mapping
  - Migration options
  - Rules and guidelines for migrating a mapping
PostgreSQL SQL ELT optimization
Data type reference

PostgreSQL Connector

Back Next

Configuring key range partition

Configure key range partition to partition PostgreSQL data based on field values. Key range is supported for only the numeric and date/time data types.

Source Properties

, click the

Partitions

tab.

Select the required

Partition Key

from the list.

Click

Add New Key Range

to add partitions.

The following image displays the details of the

Partitions

tab.

The Edit Partition Point dialog box shows Partition#1 and Partition#2. Partition#2 is selected. At the bottom of the dialog box is the partition type selection list. Key Range is selected.

Specify the

Start range

and

End range

Mappings and mapping tasks with PostgreSQL Connector

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PostgreSQL Connector

PostgreSQL Connector

Configuring key range partition

Configuring key range partition