O'Reilly logo

Microsoft SQL Server 2005 Integration Services by Kirk Haselden

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 22. Advanced Data Flow Transformations

IN THIS CHAPTER

The Slowly Changing Dimension Wizard and Transform (SCD)

Data Cleansing Components

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required