Data Quality project to clean data

Descrição

SQL Server Mapa Mental sobre Data Quality project to clean data, criado por wynand.coetzee77 em 12-03-2014.
wynand.coetzee77
Mapa Mental por wynand.coetzee77, atualizado more than 1 year ago
wynand.coetzee77
Criado por wynand.coetzee77 mais de 10 anos atrás
21
0

Resumo de Recurso

Data Quality project to clean data
  1. KB

    Anotações:

    • 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

          Anotações:

          • Process that uses sample data
          1. Domain Management

            Anotações:

            • 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

                          Anotações:

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

                            Anotações:

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

                              Anotações:

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

                              Anotações:

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

                                Anotações:

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

                                  Semelhante

                                  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