Chapter 22. Advanced Data Flow Transformations
IN THIS CHAPTER
• The Slowly Changing Dimension Wizard and Transform (SCD)
• Text Mining and Document Warehousing Components
“I KINDA THINK I WAS BEING A BIT VAGUE.”—JEFF BERNHARDT
Business Intelligence is a broad and deep field with complex and technical requirements. Take a step back and just think about the Extract, Transform, and Load (ETL) processes for a minute. Think about how many steps it takes to get dirty, duplicate, and out-of-date data from the transactional store, clean it up, transform it into a different schema, aggregate it, deduplicate it, and all the other steps you might have before pushing it into a ROLAP or MOLAP store. Integration Services provides ...
Get Microsoft SQL Server 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
