Hi Experts,
As i am new to BODS for which i would like to know what is Data Profiling and Data Quality Rules in BODS.Can i get any online material help related to both these topics
Regards,
Tarun
bo.tarun (BOB member since 2011-05-06)
Hi Experts,
As i am new to BODS for which i would like to know what is Data Profiling and Data Quality Rules in BODS.Can i get any online material help related to both these topics
Regards,
Tarun
bo.tarun (BOB member since 2011-05-06)
Briefly you would use Data Profiling in the early design phase of a project to profile the data you will be working with. For example you can analyse data in a table to check for max min values, max length of text, number of null values etc. From this you can then define validation rules - all employee records must have a date of birth and implement these in validation transforms.
Data Quality is used to improve the quality of data that is being loaded into your data warehouse - correct spelling mistakes, standardise on names or addresses (i.e. standardise on use of UK, United Kingdom, GB, Great Britain for country)
AL
agulland (BOB member since 2004-03-17)
Dear Gulland,
Thanks a lot for providing some information related to Data Profiling and Data Quality rules,If possible can you please send me any Online URL for the same.
Cheers,
Tarun
bo.tarun (BOB member since 2011-05-06)
there’s not much online resource however this link is SAPs sales pitch for data quality
A better option is to sign up to SAPs community thing and then check out examples on their Data Services Wiki.
rgds
AL
agulland (BOB member since 2004-03-17)
Dea Agulland,
Thanks a lot for giving the below links in which i am not able to see any Screens shots related to that DQ Transforms.
Cheers,
Tarun.
bo.tarun (BOB member since 2011-05-06)