Tuesday, June 24, 2014

Difference between ELT & ETL Architecture


ETL versus ELT Architecture.


Extract -- the action of reading data from a database.
Transform -- the action of transforming the extracted data from its previous form into the resultant form.
Load -- the action of writing the data into the target database. 




Difference between ELT & ETL
Column1 ETL ELT
Approach Traditional Modern/Future
Transformations Row-By-Row Bulk
Data Movement Throgh Network Twice Only Once
Engine(Staing server) Require Not Required
Database Performance No need to be high Should be high
Licensing  cost High Comparitively Low
Examples Datastage,Informatica ODI/ Sunopsis




2 comments: