Basic Storage Modes (MOLAP, ROLAP and HOLAP) in Analysis Services

Basic Storage Modes (MOLAP, ROLAP and HOLAP) in Analysis ServicesThere are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations. To learn more about these standard storage modes, pros and cons of each one, click here.

0

SQL Server Integration Services ( SSIS ) Parallel Processing

SSIS Parallel Processing Parallel execution improves the performance on the computers that have multiple physical or logical processors. To support parallel execution of different tasks in the package, SSIS uses two properties: MaxConcurrentExecutables and EngineThreads. In my next article on SSIS Parallel processing I will cover how you can utilize the parallel processing capabilities of…

0

Designing an ODS / DW with high availability and consistency

Designing an ODS / DW with high availability and consistency It’s widely recognized that database sizes are growing significantly, and that the growth is being forced by many factors, such as companies requiring more data to be available online for longer (e.g. to comply with government regulations) or an increasing amount of data being digitized…

0