Database Reference
In-Depth Information
ETL
ELT
ETLT
Extract, Transform,
and Load.
Extract, Load, and
Transform.
Extract, Transform,
Load, and Transform.
Full form
A traditional technique
for moving and trans-
forming data in which
an ETL engine that is
separate from either
the source or target
DBMS performs the
data transformations.
This is a technique for
moving and transform-
ing data from one loca-
tion and format to an-
other instance and
format. In this style of
integration, the target
DBMS becomes the
transformation engine
In this technique
transformations are
partly done by the
ETL engine and partly
pushed to the target
DBMS.
Overview
• Heavy work of
transformation
is done within
ETL engine.
• Uses in-built
transformation
functions.
• Transformation
logic can be
configured
through GUI.
• Supported by
Informatica.
• Heavy work of
transformations
is handed over
to the DBMS
layer.
• Transformation
logic runs closer
to the data.
• Supported by
Informatica.
• Transformation
work is split
between the
ETL engine
and the
DBMS.
• Facilitates ap-
plication.
• Supported by
Informatica.
Highlights
• Easy GUI-
based config-
uration.
• Transformation
logic is inde-
• Leverages
RDBMS engine
hardware for
scalability.
• Can balance/
share the
workload with
the RDBMS.
Benefits
Search WWH ::




Custom Search