What is the difference between an ETL (Extraction Transformation Load) approach and an ELT
(Extraction Load Transformation) approach to data integration? Select one.
A.
ETL can operate between heterogeneous data sources.
B.
ELT requires a separate transformation server.
C.
ELT transforms data on the target server.
D.
ELT cannot be used for incremental data loading.
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.
Reference:http://msdn.microsoft.com/en-us/library/aa480064.aspx
There is no right answer.
Rught answer is ETL requires a separate transformation server.
C.
ETL, transform data in source, another server, or in the flows to target server, applying another load to the source.
ELT, extract information and load to target, the target is not the Core app , the load does not affect the OLTP systems.
doesnot require and additional transformation Server.