What is ETL (Extract, Transform, Load)?
ETL is an abbreviation of Extract, Transform and Load. In this process, an ETL tool extracts the data from different RDBMS source systems then transforms the data like applying calculations, concatenations, etc. and then load the data into the Data Warehouse system. In ETL data is flows from the source to the target. In ETL process transformation engine takes care of any data changes.
What is ETL
What Is ELT (Extract, Load, Transform)?
ELT is a different method of looking at the tool approach to data movement. Instead of transforming the data before it’s written, ELT lets the target system to do the transformation. The data first copied to the target and then transformed in place. ELT usually used with no-Sql databases like Hadoop cluster, data appliance or cloud installation.
What is ELT
ETL vs ELT: Side-by-Side Comparison
Following are the main ETL and ELT differences:
Compute-intensive Transformations Small amount of data
