Bhalala Mihir
Tech Code

Follow

Tech Code

Follow
ETL  ELT And rETL

ETL ELT And rETL

Bhalala Mihir's photo
Bhalala Mihir
ยทDec 26, 2022ยท

2 min read

Table of contents

  • ETL (Extract, Transform, Load)
  • ELT (Extract, Load, Transform )
  • ETL VS ELT
  • Reverse ETL

ETL (Extract, Transform, Load)

Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources. It then transforms the data according to business rules, and it loads the data into a destination data store

ELT (Extract, Load, Transform )

Extract, load, transform (ELT) is a data integration process that moves data directly from source to destination for analysts to transform as needed

ETL VS ELT

ETLELT
Data is extracted from a source system, transformed on a secondary processing server, and loaded into a destination systemData is extracted from a source system, loaded into a destination system, and transformed inside the destination system
ETL is a time-intensive process. data is transformed before loading into a destination systemELT is faster by comparison. data is loaded directly into a destination system and transformed in-parallel
data output is structureddata output can be structured, semi-structured and unstructured

Reverse ETL

The reverse ETL feature lets you use the customer data residing in your data warehouse and route it to your entire data stack, including analytics, sales, and marketing tools

Reverse ETL: What Is It, How It Works & Recommended Tools

List of startups that support Reverse ETL

Rudderstack

Hightouch

Census

Grouparoo (open source)

Polytomic

Did you find this article valuable?

Support Bhalala Mihir by becoming a sponsor. Any amount is appreciated!

See recent sponsors |ย Learn more about Hashnode Sponsors
ย 
Share this