Data Quality transforms are available in the Data Quality section of the Local Object Library Transforms tab. These transforms help you to build a cleansing solution for your migrated data.
The subject of implementing Data Quality solutions in ETL processes is so vast that it probably requires a whole chapter, or even a whole book, dedicated to it. That is why we will just scratch the surface in this recipe by showing you how to use the most popular of Data Quality transforms, Data_Cleanse, to perform the simplest data cleansing task.
To build a data cleansing process, it would be ideal if we had source data which required cleansing. Unfortunately, our OLTP data source, and especially DWH data source, already contain pretty conformed and clean data. Therefore, we are going to create dirty data by concatenating multiple fields together to see how Data Services cleansing packages will automatically parse and cleanse the data out of the...