What is ETL?
ETL (Extract, Transform and Load) is a procedure in data warehousing to transform information out of the source systems and putting it into an information distribution center (Data Warehouse).
- Extract is the process of reading data from a one or multiple source systems.
- Transform is the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another system.
Transforming of data means performing any of the below tasks.
- Applying business rules (e.g. calculating new measures and dimensions),
- Cleaning (e.g. mapping NULL to 0 or "Male" to "M" and "Female" to "F" etc.),
- Filtering (e.g. selecting only certain rows/columns to load),
- Splitting a column into multiple columns and vice versa,
- Joining together data from multiple sources (e.g. lookup, merge),
- Changing date format (e.g. From YYYY-MM-DD to MM-DD-YYYY)
- Transposing rows and columns,
- Applying any kind of simple or complex data validation (e.g. if the first 2 columns in a row are empty then reject the row from processing)
- Load is the process of writing the data into the target systems (Generally Data Warehouse).
It's interesting that many of the bloggers your tips helped to clarify a few things for me as well as giving.. very specific nice content. And tell people specific ways to live their lives.Sometimes you just have to yell at people and give them a good shake to get your point across.
ReplyDeleteSAP Training in Chennai
SAP ABAP Training in Chennai
Thanks for appreciating. Really means and inspires a lot to hear from you guys.I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..Believe me, This is very helpful for me.
ReplyDeleteInformatica Training in Chennai
Dataware Housing Training in Chennai
This blog is Really Useful. keep upadatingInformatica Online Training India
ReplyDeleteThanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information.
ReplyDeleteJava training in Bangalore | Java training in Electronic city
Java training in Chennai | Java training institute in Chennai | Java course in Chennai
Java training in USA
Java training in Bangalore | Java training in Indira nagar
It would have been the happiest moment for you,I mean if we have been waiting for something to happen and when it happens we forgot all hardwork and wait for getting that happened.
ReplyDeleteOnline DevOps Certification Course - Gangboard
Best Devops Training institute in Chennai
I would like to thank you for your nicely written post, its informative and your writing style encouraged me to read it till end. Thanks
ReplyDeleteData Science Training in Indira nagar
Data Science training in marathahalli
Data Science Interview questions and answers
Data Science training in btm layout | Data Science Training in Bangalore
Data Science Training in BTM Layout | Data Science training in Bangalore
Data science training in kalyan nagar
ReplyDeleteI simply want to give you a huge thumbs up for the great info you have got here on this post.
Data science training in bangalore
It's interesting that many of the bloggers to helped clarify a few things for me as well as giving.
ReplyDeleteMost of ideas can be nice content.The people to give them a good shake to get your point and across the command.
Java training in Bangalore|best Java training in Bangalore
This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
ReplyDeleteHave you been thinking about the power sources and the tiles whom use blocks I wanted to thank you for this great read!! I definitely enjoyed every little bit of it and I have you bookmarked to check out the new stuff you post
rpa training in bangalore
best rpa training in bangalore
rpa training in pune
wonderful post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the work!!
ReplyDeleteAndroid Training in Chennai
Android Online Training in Chennai
Android Training in Bangalore
Android Training in Hyderabad
Android Training in Coimbatore
Android Training
Android Online Training
Uumso0cep_go Bianca Gutierrez https://wakelet.com/wake/NmhCW_Uu83RPTpd2Fkz-W
ReplyDeleteanabolri
perde modelleri
ReplyDeleteMobil onay
Mobil ödeme bozdurma
nft nasıl alınır
Ankara evden eve nakliyat
trafik sigortası
dedektör
Web sitesi kurmak
Ask romanlari
Smm panel
ReplyDeleteSmm panel
iş ilanları
instagram takipçi satın al
hırdavatçı
beyazesyateknikservisi.com.tr
Servis
Tiktok para hilesi indir
wolfpugKphan_koKansas City Dana Jones CyberLink YouCam
ReplyDeleteAdobe Illustrator
VMware Workstation
nyatilimna
WfauxiYfabde Barbara Jones software
ReplyDeleteLink
deretotask
Success Write content success. Thanks.
ReplyDeletebetmatik
kralbet
kıbrıs bahis siteleri
canlı slot siteleri
canlı poker siteleri
deneme bonusu
betpark
Good content. You write beautiful things.
ReplyDeletetaksi
hacklink
sportsbet
vbet
sportsbet
vbet
mrbahis
hacklink
mrbahis
شركة تسليك مجاري بالاحساء Avwfby7hWp
ReplyDelete