E-LT versus ETL

What is ETL?
ETL is acronym for Extract, Transform and Load, a process that involves extracting data from various outside sources, transformed in a proprietary middle-tier ETL engine, and finally loaded into the target.

• In this, developer must define every step of Complex ETL Flow Logic.
• Traditional approach requires specialized ETL Skills.
• It require significant development and maintenance Efforts.

What is E-LT?
E-LT is acronym for Extract, Load and Transform, a process where data is first extracted from various sources, loaded into the Target server and finally, transformed on the target RDBMS using native SQL operators.
• It simplifies the number of steps.
• And automatically generates the Data Flow whatever the sources and target DB.

Difference between ETL and E-LT.

ETL E-LT
•Poor performance due to the middle-tier ETL engine.

–Row-by-row processing.

–Data is moved over the network twice.

 

•Transformations are executed in the middle-tier ETL engine which reduces performance.

•Proprietary engine increases hardware and maintenance costs.

–Requires special skill set to manage the               proprietary engine.

•High performance as there is no middle-tier engine.

–Set-based processing.

–Only relevant data is moved to the target server.

•Transformations are executed in the target RDBMS server which is more powerful than a middle-tier ETL engine.

•No proprietary engine to maintain.

–Simple Maintenance.

–No special skill set required.

Leave a Reply