Data Quality project to clean data

Descripción

SQL Server Mapa Mental sobre Data Quality project to clean data, creado por wynand.coetzee77 el 12/03/2014.
wynand.coetzee77
Mapa Mental por wynand.coetzee77, actualizado hace más de 1 año
wynand.coetzee77
Creado por wynand.coetzee77 hace más de 10 años
22
0

Resumen del Recurso

Data Quality project to clean data
  1. KB

    Nota:

    • 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

          Nota:

          • Process that uses sample data
          1. Domain Management

            Nota:

            • 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

                          Nota:

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

                            Nota:

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

                              Nota:

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

                              Nota:

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

                                Nota:

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

                                  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