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




3 comments:

  1. Very well explained thanks for your blog. Keep posting.
    etl testing course
    etl testing online

    ReplyDelete
  2. IntelliMindz is the best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.

    ETL Testing Online Training
    ETL Testing Course In Bangalore
    ETL Testing Course In Chennai
    ETL Testing Course In Coimbatore

    ReplyDelete
  3. Excellent explanation! Simple, clear, and beginner-friendly. For anyone looking to learn more, check out ETL-Tutorial.

    ReplyDelete