Can any help me out with the difference between ETL and ELT

General
Enthusiast

Can any help me out with the difference between ETL and ELT

I am studying an article and confused with ETL and ELT strategy.Can any one help me with comparing the following parameters network bandwidth,cpu,I/o,perm space,spool space kinds if things.

1 REPLY
Enthusiast

Re: Can any help me out with the difference between ETL and ELT

Mostly proprietary ETL tools perform ETL task on a row-by-row basis. So performance will be hit. So think of the advantage of doing voluminous transformation(T) at the target server, performing set processing. In this way , the network traffic is hugely reduced.I/O contention will be reduced for bulk load. Many  ELT tools too work well with event-based data.Few ETL tools have Pushdown optimization techniques. Need to see the best of breed :)