InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Partition, How Will You Implement It? |
|
Answer» You can use the Partition Wizard to define partitions for a measure group in a cube. By default, a single partition is defined for each measure group in a cube. Access and processing performance, however, can degrade for large partitions. By CREATING MULTIPLE partitions, each containing a PORTION of the DATA for a measure group, you can improve the access and processing performance for that measure group. You can use the Partition Wizard to define partitions for a measure group in a cube. By default, a single partition is defined for each measure group in a cube. Access and processing performance, however, can degrade for large partitions. By creating multiple partitions, each containing a portion of the data for a measure group, you can improve the access and processing performance for that measure group. |
|