Data Quality project to clean data

Data Quality project to clean data

1. KB

   • Create a KB interactively or from a auto discovery of trustworthy data
   • KB consists of domains that map to data source fields
   • Build KB
     • Process to build KB
       • Knowledge Discovery
         • Process that uses sample data
       • Domain Management
         • Process that verifies and extends domains
         • Import & Export
           • KB from other DQS Instances
           • KB from DQC
           • Domain from DQC
           • Values from Excell
           • Domains from Excell
           • Values from a finished DQS project
         • Domain Rules
           • Condition that DQS uses to validate domain Values
         • Term based Relations
           • To correct a term that is part of a domain
         • Composite Domain
           • Consists of two or more singe domains
       • Reference data services
         • Process that validates domain data against external data 
       • Matching Policy
         • Process that defines rules that identifies duplicates

2. Stages of DQP

   • Mapping
   • computer assisted cleansing
   • Interactive ceansing
   • Export