In a Datawarehouse setup, the quintessential decision needs to be taken is how to load the data. There are couple of standard ways in DW Full Load : Where the complete set of data will be loaded into DW table…