Handling Data Integrity Issues in Analysis Services 2005 (MS paper)
| Handling Data Integrity Issues in Analysis Services 2005 (MS paper) |
| Written by T.K. Anand |
| Saturday, 19 May 2007 19:02 |
|
Summary: Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them. (10 printed pages) ContentsIntroduction IntroductionData integrity issues are common in relational databases, especially in operational (OLTP) systems. These issues are typically fixed by ETL (Extraction, Transformation and Load) jobs that load the data into a data warehouse. However it is not uncommon to have some integrity issues even in data warehouses. SQL Server 2005 Analysis Services supports cubes built directly from operational data stores, and it offers some sophisticated controls to manage the data integrity issues inherent in such systems. Database administrators can greatly simplify their cube management tasks by exploiting these controls. |
Tags: dw, paper, ssis
Top Rated
- MS Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
- SQL Server 2008 White Paper: Analysis Services Performance Guide
- Functionality & Performance Testing Analysis Services 2005 with Teradata v12
- Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
- Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
- MS Paper: 2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005
- Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows XP
- Why Local Cube Creation with ASSL is Superior to Local Cube Creation with the Create Global Cube Com
