on 02-06-2012 10:27 AM
HI All,
I am looking to know much about Data Profiling and Data Steward features of BODS.. Can any one share some light and links on this.
I want to see the how accurate the data from source and how it is going out from DS.. want some graphical view on data..
Thanks
Rajeev
Hi Suneer,
How is Data profiling using BODS different from Data profiling using SAP-IS?? Are the two same or are the two different functions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There are two types of Profiling:
1) Column Profiling and
This will let you understand what are the unique values present in the column, min / max values, how many null values / blanks, their percentage, max /min / avg string length etc.
2) Relationship profiling
Lets you know the what percentage / no: of records of a table A is present in table B.
In the both these, there are basic / detailed profiling. For the latter, some attributes will be more.
For Data Profiling, you require
1) Designer Access.
2) A profiler repository.
3) Job Server associated with a repository.
4) A profiler user or profiler administrator set in Management Console.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
Data Profiling:
Data profiling is a feature of SAP BODS. Data profiling handles the inconsistencies seen in data. When data comes in through a single interface, the program can validate data as it is entered. But in many other cases, data comes in a much less consistent way, with improperly formatted social security numbers, invalid values for certain fields, missing data, and the like. SAP BODS data profiling ensures that data is complete, consistently formatted, and valid.
Information Steward:
The Information Steward solution provides continuous insight into the quality of your data. Giving the power to improve the effectiveness of your operational, analytical, and governance initiatives.
A Data Steward Reviews data quality scorecard & Analyzes Scorecard.
Please check the below doc for more info on the same:
Hope it helps.
Regards,
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.