Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Setting Up Key-Range Partitioning for Relational Data Sources

Setting Up Key-Range Partitioning for Relational Data Sources

Complete the following steps to set up key-range partitioning for relational data sources.
  1. In the Task Developer, double-click the session to open the session properties.
  2. On the
    Mapping
    tab, click the
    Partitions
    view.
  3. Select the Source Qualifier transformation, and click
    Edit Partition Point
    .
    The
    Edit Partition Point
    dialog box appears.
  4. Click
    Add
    for each partition that you want to add.
  5. In the
    Partition Type
    list, select
    Key Range
    .
  6. In the
    Edit Partition Key
    dialog box, select one or more ports for the key, and click
    OK
    .
  7. For each partition, enter values in the
    Start Range
    and
    End Range
    boxes.
  8. Click
    OK
    .

0 COMMENTS

We’d like to hear from you!