Handling Data Integrity Issues in Analysis Services 2005 (MS paper)
Summary: Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them. (10 printed pages)
Contents
Introduction
Types of Data Integrity Issues
Data Integrity Controls
Scenarios
Conclusion
Introduction
Data 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.