Two types of load in ETL.
- Full load — loading entire data from source to destination. Suitable for smaller source data
- Incremental/Delta Load — loading only the data from source which are not available in destination. Suitable if source datasize is huge. Usually it is implemented based on date.