GeekArticles 
Data Warehousing Analysis ServicesMerging Partitions
Author: exforsys.com |
Published: 22nd Aug 2005 |
Visited: 310 times |
Add CommentFiled in: OLAPCubes with multiple partitions can be extremely confusing. Users may like to organize the cubes into a cube with fewer partitions by merging some of the partitions together. The preconditions to the merger of cubes is that the Storage and aggregation design should be the same in the partitions being merged.
Read Article Sponsored Links
Related Articles
• Partitioning tables with unequal partitions. Hi Tom,
We have data coming into our application from different entities/agencies and being loaded into several different tables. Each transmission contains data that belongs to a unique entity. We can also receive a new transmission for each ent ...
• warehouse partitions and execution plans hi tom
in oracle we have two types of histograms height based and width based. why we have two types of histrograms? do these two histograms effect execution plan. because histograms represents data skewness. does data skewness in both the histog ...
• partitions and parallel processing hi tom
thanks for this wonderful forum
I have a question regarding oracle parallel processing and partition. before oracle 9.2 parallel processing is not possible without partitioning and DOP was equal to number of partitions. however this beh ...
• Database Partitions Task Database Partitions for SSIS is a new Control Flow Task for managing database partitions in SQL Server 2005. Key features are - . Create partition table based on target table. Insert partition table into target table. Remove partition from target table. Combine smaller partitions into a larger ...
• "Selective" Indexing of Partitions Hi Tom,
Do you know of any plans to allow indexing of only selected partitions, not all of them? For example, if partitions are significantly different in size or if data in one of them is skewed it may be beneficial to have an index on one and n ...
• "Selective" Indexing of Partitions Hi Tom,
Do you know of any plans to allow indexing of only selected partitions, not all of them? For example, if partitions are significantly different in size or if data in one of them is skewed it may be beneficial to have an index on one and n ...
• Partitions and tablespaces I have an application that collects different data from several probes. Data are processed and written to the database, where analysis is performed. Data once written are never updated, only queried. Data will be store in a FiberChannel SAN using SA ...
