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 |
No comments:
Post a Comment