Database Reference
In-Depth Information
•
Database partition
: This type of partitioning is possible with the Oracle or DB2
database. When you select database partitioning, Integration Service reads the
partitioning information from the nodes in the database.
•
Hash auto-keys
: In hash auto-key partitioning, Integration Service divides the
data based on the partition key using the hash function. All the grouped and sor-
ted ports in transformations are used as partition keys. This type of partition can
be used in Rank, Sorter, and Aggregator transformations.
•
Hash user keys
: Similar to hash auto-keys, Integration Service in this portioning
uses the hash function to partition the data. You need to manually define the num-
ber of ports for the partition key.