Data loading process in ETL loads the prepared data from staging tables to main tables.


ETL has three types of data loading:

  • Initial Load: It populates data tables from the source table and loads them in the data warehouse table.
  • Full Refresh: It erases the data from one or more tables completely and reloads the fresh data.
  • Incremental Load: It applies the ongoing changes as required periodically.
BY Best Interview Question ON 26 Jan 2019