Explain the data loading types.
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.