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.
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 |
Very well explained thanks for your blog. Keep posting.
ReplyDeleteetl testing course
etl testing online
IntelliMindz is the best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.
ReplyDeleteETL Testing Online Training
ETL Testing Course In Bangalore
ETL Testing Course In Chennai
ETL Testing Course In Coimbatore