Metadata versus warehouse partition mapping - Microstrategy

Before MicroStrategy 7, warehouse partition mapping was the only type of application-level partition mapping available. Now you have a second option, metadata partition mapping, which does not require any additional tables in the warehouse. Metadata partition mapping is generally recommended over warehouse partition mapping in MicroStrategy. However, if you already have partition mapping tables that you set up in MicroStrategy 6.x, you can continue to use warehouse partition mapping in MicroStrategy. The basic concepts are similar between the two strategies.

Metadata partition mapping is recommended because you do not need to create and maintain partition mapping tables in the warehouse. You create the rules in MicroStrategy that the Query Engine uses to generate the SQL to run reports. Because you create the partitions directly in the metadata, it is easier to maintain.

Metadata partition mapping also allows both heterogeneous and homogenous partitions, unlike warehouse partition mapping. Only homogenous partitions can be used in warehouse partition mapping.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Microstrategy Topics