Data Quality project to clean data

Description

SQL Server Mind Map on Data Quality project to clean data, created by wynand.coetzee77 on 12/03/2014.
wynand.coetzee77
Mind Map by wynand.coetzee77, updated more than 1 year ago
wynand.coetzee77
Created by wynand.coetzee77 about 10 years ago
21
0

Resource summary

Data Quality project to clean data
  1. KB

    Annotations:

    • Create a KB interactively or from a auto discovery of trustworthy data
    • KB consists of domains that map to data source fields
    1. Build KB
      1. Process to build KB
        1. Knowledge Discovery

          Annotations:

          • Process that uses sample data
          1. Domain Management

            Annotations:

            • Process that verifies and extends domains
            1. Import & Export
              1. KB from other DQS Instances
                1. KB from DQC
                  1. Domain from DQC
                    1. Values from Excell
                      1. Domains from Excell
                        1. Values from a finished DQS project
                        2. Domain Rules

                          Annotations:

                          • Condition that DQS uses to validate domain Values
                          1. Term based Relations

                            Annotations:

                            • To correct a term that is part of a domain
                            1. Composite Domain

                              Annotations:

                              • Consists of two or more singe domains
                            2. Reference data services

                              Annotations:

                              • Process that validates domain data against external data 
                              1. Matching Policy

                                Annotations:

                                • Process that defines rules that identifies duplicates
                          2. Stages of DQP
                            1. Mapping
                              1. computer assisted cleansing
                                1. Interactive ceansing
                                  1. Export
                                  Show full summary Hide full summary

                                  Similar

                                  70-458
                                  Ben Odunjo
                                  SQL Azure Identity Jumping
                                  Mary Macdonald
                                  Package Properties at Run Time
                                  wynand.coetzee77
                                  Script Components
                                  wynand.coetzee77
                                  Managing Master Data
                                  wynand.coetzee77
                                  Deploy package to file system
                                  wynand.coetzee77
                                  DQS Permissions
                                  wynand.coetzee77
                                  BASES DE DATOS
                                  Hernando Castro
                                  INTELIGENCIAS MÚLTIPLES
                                  Nadia Salazar
                                  BASES DE DATOS
                                  Shanella Percel
                                  BASES DE DATOS
                                  emily urrutia