Load a large dimension with load partitioning

Loading a large dimension (that is, a dimension with no historical attributes) requires processing of the ETL in multiple batches. Processing of the ETL in multiple batches can be done using the load partitioning capabilities of your ETL tool.

If you are using Infosphere Datastage, refer to IBM InfoSphere Information Server documentation for more information about load partitioning. If you are using any other ETL tool, refer to the corresponding product documentation for more information.

With the partitions configured, proceed to run load management for the dimension as you would normally.