O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

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

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

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