Partitioning data for a write operation

You can specify how the incoming data is partitioned or collected before the data is written to the Netezza database. You can also specify that the data should be sorted before being written.

Before you begin

The availability of partition or collection type depends on whether you design your Netezza connector job to run in parallel or sequential mode.

The Partition type list is available if you set the Netezza Connector stage to run in parallel mode. If you select a method from the list, the method overrides any current partitioning method.
The Collection type list is available if you set the Netezza Connector stage to run in sequential mode, and the preceding stage is set to run in parallel mode.

Procedure

On the job design canvas, double-click the Netezza connector icon.
In the top left corner of the stage editor, select the input link that you want to edit.
Click the Partitioning tab.
Select a partition type from the Partition type/Collection type list. Select the type of data partitioning or collection method to the data that you want to write. Click the Properties icon next to the Partition type list to specify the required database, instance, and table.
Click OK.