Data Warehousing What is data profiling.

Hi Reader,

Data profiling is a process whereby one examines the data available in an existing database and collects statistics and information about that data. The purpose of these statistics may be to:

1.find out whether existing data can easily be used for other purposes
2.give metrics on data quality including whether the data conforms to company standards
3.assess the risk involved in integrating data for new applications, including the challenges of joins
4.track data quality
5.assess whether metadata accurately describes the actual values in the source database
6.understanding data challenges early in any data intensive project, so that late project surprises are avoided. Finding data problems late in the project can incur time delays and project cost overruns.

data profiling - Its a concept and a tool for the ongoing development work in the creation of our Data Warehouse. Profiling is now considered a very important component of any Data Warehousing methodology, and it certainly assists us by shortening the development process.

Understanding the very nature and structure of the data originating in source systems helps to avoid working on assumptions and costly re-development at a later stage. Even if you're doing profiling manually, as its been done normally- olden days.

That's what is from my point of view. I've extracted this info from different sites and gather the information. If its not apt to what u are looking for then pls ignore this ..Else if you need any further details on DWH or Data Migration
pls do revert at
venkata dot veluri at gmail dot com

Regards
Venkat