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.
Microstrategy Related Interview Questions
|Informatica Interview Questions||IBM Cognos Interview Questions|
|Teradata Interview Questions||Adv Java Interview Questions|
|Cloud Computing Interview Questions||SQL Database Interview Questions|
|OBIEE Interview Questions||Qlik View Interview Questions|
|Tableau Interview Questions||Talend Interview Questions|
|IBM Cognos TM1 Interview Questions||Data modeling Interview Questions|
|Cognos ReportNet (CRN) Interview Questions||Qlik Sense Interview Questions|
Introduction To Advanced Reporting
Creating Freeform Sql Reports
Creating Olap Cube Reports
Data Mining Services
Custom Groups And Consolidations
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.