What is the difference between an ETL (Extraction Transformation Load) approach and an ELT (Extraction Load Transformation) approach to data integration? Select one.

The correct answer is B. ELT requires a separate transformation server. There are two approaches to consider for data integration: ELT and ETL. The difference between ETL and ELT lies in the environment in which the data transformations are applied. In traditional ETL, the transformation takes place when the data is en route from the source to the…

Loading Data into the Data Warehouse

Question

Options

AETL can operate between heterogeneous data sources.
BELT requires a separate transformation server.
CELT transforms data on the target server.
DELT cannot be used for incremental data loading.

How the community answered

(27 responses)

A
19% (5)
B
70% (19)
C
7% (2)
D
4% (1)

Explanation

There are two approaches to consider for data integration: ELT and ETL. The difference between ETL and ELT lies in the environment in which the data transformations are applied. In traditional ETL, the transformation takes place when the data is en route from the source to the target system. In ELT, the data is loaded into the target system, and then transformed within the target system environment.

Topics

#ETL#ELT#data integration#transformation approaches

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice