1.

Explain the data loading types.

Answer»

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.


Discussion

No Comment Found

Related InterviewSolutions