Covers: theory of ELT process
Estimated time needed to finish: 20 minutes
Questions this item addresses:
  • How ELT works?
  • What is the benefits of ELT?
  • What is the different of ELT and ETL?
How to use this item?

Extract/load/transform (ELT) is the process of extracting data from one or multiple sources and loading it into a target data warehouse. Instead of transforming the data before it’s written, ELT takes advantage of the target system to do the data transformation.

Read the whole article for more explaination about the process.

Author(s) / creator(s) / reference(s)
talend.com
0 comment
Recipe
publicShare
Star0

Overview of ELT/ETL

Contributors
Total time needed: ~2 hours
Objectives
Introduce about ELT/ETL process and some useful tools. ETL/ETL tools are the first essential step in the data warehousing process, which helps break down data silos and makes it easy for data scientists to access and analyze data, and turn it into business intelligence.
Potential Use Cases
Learning about data management in MLOps
Who is This For ?
BEGINNERML Engineer
Click on each of the following annotated items to see details.
ARTICLE 1. Data Engineering (CS 329S)
  • What is OLTP and OLAP?
  • What is structured and unstructured data?
  • What is ELT and ETL?
10 minutes
ARTICLE 2. What is Extract, Transform, Load? Definition, Process, and Tools
  • How ETL works?
20 minutes
ARTICLE 3. What is ELT
  • How ELT works?
  • What is the benefits of ELT?
  • What is the different of ELT and ETL?
20 minutes
ARTICLE 4. ELT Tools
  • What are some ELT tools?
20 minutes

Concepts Covered

0 comment