Processing terabytes of data requires heavy infrastructure setup.
| Feature | ETL (Extract, Transform, Load) | ELT (Extract, Load, Transform) | | :--- | :--- | :--- | | | Extract -> Transform -> Load | Extract -> Load -> Transform | | Transformation Location | Done on a separate engine (like Spark/Hive) before loading. | Done inside the destination data warehouse (like Synapse). | | ADF Role | ADF orchestrates the external transformation. | ADF moves raw data; transformation happens in the warehouse. | javatpoint azure data factory
E.g., Hive, Pig, MapReduce, Spark, Azure Databricks, and Data Flow. Load) | ELT (Extract
Name: Enter a globally unique name (e.g., adf-demo-tutorial-2026 ). Version: Select . Click Review + Create , then click Create . Load | Extract ->