When you set up partitioning,

Data Integration Hub

reduces fragmentation by deleting expired data sets and reducing the time of data set creation and data consumption. You can set up partitions on Oracle and Microsoft SQL Server databases.

Use the

Data Integration Hub

repository utility command

enablePartitioning

to create and manage the partitions in the publication repository database. The partitions state appears in the dih.staging.use.partitions.default system property. For more information about the

Data Integration Hub

repository utility see the

Data Integration Hub

Administrator Guide

.

If you switch between a partitioned database and a non-partitioned database, the change affects topics, publications, and subscriptions that you create after the switch. Therefore, it is recommended that you choose a partition state before you start to use

Data Integration Hub

. To switch the partition state for existing topics, publications, or subscriptions, contact Informatica Global Customer Service.