Skip to Content
Author's profile photo Johnpaul Joseph

Pattern Check using SAP Information Steward

Pattern Check using SAP Information Steward

SAP Information Steward is a very good tool for all the Data Quality profiling activities. Using the Profile Attribute setting “Distribution”, we can measure and validate the Pattern & Word Distribution on the Particular column. For example in the Email Address Column we can do a quick sampling on the whole lot of records and analyse how many records coming in each pattern.


/wp-content/uploads/2013/05/img1_213793.jpg

Step 1: Select a Table and apply ‘Column Profiling’ as shown below.

/wp-content/uploads/2013/05/img2_213881.jpg

Step 2: Select Median & Word Distribution options

/wp-content/uploads/2013/05/img3_213882.jpg

Step 3: Save & Run the Task


All the patterns are captured by Info Steward

/wp-content/uploads/2013/05/img4_213883.jpg

Step 4: Lets select the Email Address Pattern. It will lists all the 6 pattern in the right pane.

/wp-content/uploads/2013/05/img5_213884.jpg

Step 5: If you select the pattern, it will show the corresponding Record of the particular pattern.

/wp-content/uploads/2013/05/img6_213885.jpg

This will reduce lot of sampling &manual efforts of analyzing the data.

Cheers

John Paul Joseph

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Niels Weigel
      Niels Weigel

      Great quick post on Pattern Analysis within Information Steward. You might find more information on Information Steward on our specific SCN side for Information Steward:

      http://scn.sap.com/community/information-steward

      Niels

      Author's profile photo Johnpaul Joseph
      Johnpaul Joseph
      Blog Post Author

      Thanks Niels, Moving onwards i will share more thoughts about Info Steward.

      John