Skip to Content

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

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply