Mapa mental
ETL TOOLS

Conteúdo do mapa
ETL TOOLS
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.
(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.
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.
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.
Imagens e arquivos do mapa
Informações
- Descrição
- Economía Mapa Mental sobre ETL TOOLS, criado por Jefferson Guillermo Bejarano Granados em 03-05-2018.
- Criado por
- Jefferson Guillermo Bejarano Granados
- Visualizações
- 7
- Avaliação
