1153
Chapter 51: Business Intelligence Database Design
51
FIGURE 51-6
When a row is inserted and a version of that row exists, the bit fl ag for the existing row is set
to off, and the end date is set to the date and time of insertion of the new row.You can use several methods to accomplish the Type 1 and Type 2 changes. Using SSIS you
can implement many frameworks, or you can use the built-in Slowly Changing Dimension
task. More details on this task are explained in Chapter 52, “Building, Deploying, and
Managing ETL Workfl ows in Integration Services.” If you are not well versed with SSIS and
prefer to use T-SQL, you can use the MERGE keyword.Summary
BI provides a consistent view of the data across the entire organization. In addition, it
relieves the contention possibilities and provides a means for historical reporting of your
operations data. In the end, your organization has the capability to provide secure and
accurate data without the complexities and dependencies on your OLTP system.The concepts introduced in this chapter should provide a foundation that prepares you to
leverage the Integration and Analysis Services chapters in this book.c51.indd 1153c51.indd 1153 7/31/2012 10:28:43 AM7/31/2012 10:28:43 AM
http://www.it-ebooks.info