Skip to main content Skip to main navigation Skip to search Skip to footer

Data Profiling - A Quick Primer on the What and the Why of Data Integration

Download PDF: 
Published Date: 
Apr 12, 2011
Download PDF: 


Databases in most companies have evolved in an ad-hoc manner, which has resulted in  information  silos. Companies, therefore, do not have  a unified view of their customers, resulting in missed business opportunities or increased  cost of operations.  Data integration addresses those issues, but poses data verification challenges, since the source data are in diverse databases.  Most data  integration and  migration projects overshoot their time and cost estimates because of the effort expended to understand the source data. Data profiling  automates the identification of problematic source data, inconsistencies, redundancies, and inaccuracies.  Data profiling also provides a factual foundation, based  on which  data can be  cleansed and then consolidated  before integration.
Excerpts from the Paper
A company’s database  contains information that touches most  aspects of its  business activity market data, customer information, accounting information, production details, sales records, billing details,  collection details, personnel records, salary records, and  so on. This data is utilized by the company for various business decisions, and it is therefore imperative that the  data  in the database  be consistent, accurate and reliable. Since the costs of poor data quality are high, increasingly  companies are “profiling data” to  check its quality and suitability for business. Data profiling uses “analytical techniques to discover the true content, structure, and quality of data.”


Site Section: 
To download this resource
Please fill in following form :
Contact Us
Uploaded file should not exceed 15 MB. Allowed extensions are.pdf, .doc, .docx, .rtf., ppt, .pptx , .xls, .xlsx & .xps (Max 4 files)

Facts about HCL Technologies

  • $5.7 billion global company delivering measurable business value in enterprise application services, IT infrastructure management, custom application services, engineering and R&D services, and business services
  • Extensive global offshore infrastructure and network of offices in 31 countries
  • Providing holistic, multi-service delivery across industries — financial services, manufacturing, consumer services, public services, and healthcare