Full Load
The data is loaded to the Warehouse for the first time.
Incremental Load
Next time onwards incremental load is done. The data is appended to the historical data.
We generally do this type of load.
Refresh Load
Suppose the data loaded is full of errors, entire data is reloaded. In this case only we need the Truncate Target Table Option. Rarely used.
Comments
Post a Comment