Data Quality project to clean data

Beschreibung

SQL Server Mindmap am Data Quality project to clean data, erstellt von wynand.coetzee77 am 12/03/2014.
wynand.coetzee77
Mindmap von wynand.coetzee77, aktualisiert more than 1 year ago
wynand.coetzee77
Erstellt von wynand.coetzee77 vor mehr als 10 Jahre
22
0

Zusammenfassung der Ressource

Data Quality project to clean data
  1. KB

    Anmerkungen:

    • 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

          Anmerkungen:

          • Process that uses sample data
          1. Domain Management

            Anmerkungen:

            • 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

                          Anmerkungen:

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

                            Anmerkungen:

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

                              Anmerkungen:

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

                              Anmerkungen:

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

                                Anmerkungen:

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

                                  ähnlicher Inhalt

                                  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