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.
|•Poor performance due to the middle-tier ETL engine.
–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.
–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.
–No special skill set required.