Home > Information Steward > Fun and Useful Features in SAP Information Steward 4.2

Fun and Useful Features in SAP Information Steward 4.2

The latest release of SAP Information Steward includes the Data Cleansing Advisor, which has some great new features that help organizations get a jump-start on their Information Steward implementation. Today I’ll show an example process for using Data Cleansing Advisor to suggest Information Steward validation rules and create a cleansing solution.

Profiling the Data

The first step in generation cleansing rules is to have Information Steward profile the data. First, create a column profiling task (select table →Profile→Columns) and make sure to select the advanced profiling options “Median & Distribution” and “Word distribution”.

IS 4.2 1

Next, create a Content Type profiling task (select table →Profile→Content Type).

IS 4.2 2

Data Validation Advisor Suggestions

Once these tasks have been run, returning to the Workspace Home→Profile Results→Advanced tab will indicate with icons in the “Advisor” column if any validation or data cleansing rules have been suggested. As shown in the figure below, the golden gear icon indicates suggested validation rules, and the broom icon indicated cleansing advisor rules.

IS 4.2 3

Clicking on the Data Validation Advisor (golden gear icon) opens up the list of suggested validation rules, as shown in the image below. These rules typically suggest non-null nor non-zero columns, and sometimes pick up patterns (for example that a column should have only Y or N). Since this is a small set of fake data, the rules are relatively simplistic, but potentially still useful.

To download PDF, and Continue Reading…

Hilary BlissAbout Hillary Bliss

Hillary Bliss is the Analytics Practice Lead at Decision First Technologies, and specializes in data warehouse design, ETL development, statistical analysis, and predictive modeling. She works with clients and vendor to integrate business analysis and predictive modeling solutions into the organizational data warehouse and business intelligence environments based on their specific operational and strategic business needs. She has a master’s degree in statistics and an MBA from Georgia Tech.

Categories: Information Steward
  1. June 12, 2014 at 11:32 am

    I couldn’t resist commenting. Well written!

  2. June 12, 2014 at 11:39 am

    I’m not sure where you are getting your information, but great topic.
    I needs to spend some time learning more or understanding more.
    Thanks for magnificent info I was looking for this info
    for my mission.

  3. kishore
    February 12, 2015 at 2:05 am

    blog is good but you can maintain screen shots it will be helpful to understand easily.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: