Gestalte GoConqr mit. Was sollen wir als Nächstes hinzufügen?

Mindmap

ETL TOOLS

Jefferson Guillermo Bejarano Granados Economía Spanisch

ETL TOOLS

Inhalt der Mindmap

ETL TOOLS

  1. LOAD: once the data has been extracted, transformed and cleaned, it must be loaded into the data warehouse to make it available to analysts and can be used by decision support applications.

  2. (Extraction, Transformation, Load). ETL refers to software tools that are dedicated to the automatic execution of the three main tasks: extract, transform and load. The process of loading a data warehouse requires the completion of the three phases.

  3. REMOVAL: the data is extracted from the available internal and external sources (reading data from one or more databases). Data sources can consist of files extracted from OLTP databases, calculation tools, personal databases or external files and flat files.

  4. TRANSFORMATION: The objective of this phase (transformation and cleaning) is to improve the quality of the data extracted from the different sources by means of corrections of inconsistencies, inaccuracies and loss of values. The main ones, which are eliminated during the transformation and data cleaning phase are:

    • Inconsistencies between registered values with different attributes that have the same meaning, duplication of data, loss of data, existence of inadmissible values.

Bilder und Dateien der Mindmap

  • ETL TOOLS
  • ETL TOOLS

Informationen

Beschreibung
Economía Mindmap am ETL TOOLS, erstellt von Jefferson Guillermo Bejarano Granados am 03/05/2018.
Aufrufe
7
Bewertung

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?