Creating a custom cleansing package with Cleansing Package Builder

In Chapter 7, Validating and Cleansing Data (see the recipe Data Quality transforms – cleansing your data), we already used the default cleansing package PERSON_FIRM available in Data Services for data cleansing tasks.

In this recipe, we will create a new cleansing package from scratch with the help of Information Steward and publish it so that it can be used in Data Services transforms.

Our new custom cleansing package will be used to determine the type of street used in the address field of the Address table from the OLTP database.

Getting ready

The Information Steward Cleansing Package Builder tool requires a sample flat file with data that is used to define cleansing rules. The ...

Get SAP Data Services 4.x Cookbook 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.