what is the difference between ETL and ELT ?
ETL
The transformations are processed by the ETL tools (Informatica , Datastage etc) while in ELT the transformations are processed by the target datasources (RDBMS). I guess that the rising scalability of databases allows this kind of data integration to be possible.
So the important thing to remember is the side where the transformations are processed.
I made the following schema to help remember the difference :
ELT
This is appropriate for databases like Teradata & Netezza and this approach is the Future . The Engine which Teradata uses is efficient and Super fast at ELT (Extract, Load, Transform) data processing.
ELT should be preferred , instead of ETL, in below cases :
there are big volumes of data
the source database and the target database are the same
the database engine is well adapted for that kind of processing (ex: Teradata)
ETL
The transformations are processed by the ETL tools (Informatica , Datastage etc) while in ELT the transformations are processed by the target datasources (RDBMS). I guess that the rising scalability of databases allows this kind of data integration to be possible.
So the important thing to remember is the side where the transformations are processed.
I made the following schema to help remember the difference :
ELT
This is appropriate for databases like Teradata & Netezza and this approach is the Future . The Engine which Teradata uses is efficient and Super fast at ELT (Extract, Load, Transform) data processing.
ELT should be preferred , instead of ETL, in below cases :
ReplyDeleteThanks for the nice blog here.I was searching this one for a long time.This blog is very helpful for my studies..I got another one site also,which is same as yours Oracle ODI .Check this one also Oracle Fusion Manufacturing .Sure it will be helpful for you too..Once more iam thanking you for your creative blog.
kayseriescortu.com - alacam.org - xescortun.com
ReplyDeleteinstagram takipçi satın al
ReplyDeleteucuz takipçi
takipçi satın al
https://takipcikenti.com
https://ucsatinal.org
instagram takipçi satın al
https://perdemodelleri.org
https://yazanadam.com
instagram takipçi satın al
balon perdeler
petek üstü perde
mutfak tül modelleri
kısa perde modelleri
fon perde modelleri
tül perde modelleri
https://atakanmedya.com
https://fatihmedya.com
https://smmpaketleri.com
https://takipcialdim.com
https://yazanadam.com
yasaklı sitelere giriş
aşk kitapları
yabancı şarkılar
sigorta sorgula
https://cozumlec.com
word indir ücretsiz
tiktok jeton hilesi
rastgele görüntülü sohbet
fitness moves
gym workouts
https://marsbahiscasino.org
http://4mcafee.com
http://paydayloansonlineare.com
Accounts Officer exam paper
ReplyDeleteclass 9 tuition classes in gurgaon
laboratory furniture manufacturer
world777
cloudkeeda
what is azure
azure free account
azure data factory
A Dedicated Server requires an operating system that is compatible with the server hardware and the applications or services.
ReplyDeleteElevate your online presence with powerful dedicated server miami. Experience unmatched performance and reliability for your business needs.
ReplyDeleteEscape to a luxurious best resort in jaipur, where royal elegance meets modern comfort. Enjoy world-class amenities, serene landscapes, and unforgettable experiences.
ReplyDelete