Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11: Advanced Data Cleansing in SSIS

Chapter 11

Advanced Data Cleansing in SSIS

WHAT’S IN THIS CHAPTER?

  • Using the Derived Column Transformation for advanced data cleansing
  • Applying the Fuzzy Lookup and Fuzzy Grouping Transformations and understanding how they work
  • Introducing the SQL Server 2012 technology Data Quality Services

In this chapter, you will learn the ins and outs of data cleansing in SSIS, from the basics to the advanced. In a broad sense, one of SSIS’s main purposes is to cleanse data — that is, transform data from a source to a destination and perform operations on it along the way. In that sense, someone could correctly say that every transformation in SSIS is about data cleansing. For example, consider the following transformations:

  • The Data Conversion adjusts data types.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint