Help shape GoConqr. What should we add next?

Mind map

ETL TOOLS

Jefferson Guillermo Bejarano Granados Economía Spanish

ETL TOOLS

Map content

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.

Images and files in the map

  • ETL TOOLS
  • ETL TOOLS

Information

Description
Economía Mind Map on ETL TOOLS, created by Jefferson Guillermo Bejarano Granados on 03/05/2018.
Views
7
Rating

Feedback

What is it about?

What should we add next?