SSIS Tutorials - 20.Full Load and Incremental Load in SSIS
Destructive Load
Also known as Full Load, is a process of completely destroying/deleting the existing data and reloading it from scratch. A lot of unchanged data is also deleted and reloaded in this process. But a destructive load ensures the highest data integrity easily.
“Delete destination data. Read data from source. Load into destination.”
Incremental Load
Incremental load is a process of loading data incrementally. Only new and changed data is loaded to the destination. Data that didn’t change will be left alone. Data integrity can be ensured in this process too, but ETL can get complicated.
Last but not the least, SUBSCRIBE to my YouTube channel to stay updated about the regularly uploaded new videos.
My channel : / @melvinking7477
Linkedin : / mohammed-rasool