In this session you will learn about Partial load
Partial Reload
--------------------
- Instead of executing entire script, If we want to execute only particular portion of the script, we need to Perform Partial Reload
- To Perform Partial Reload, Give 'Add' Qualifier before LOAD or SELECT Statement
- To separate normal Reload with Partial Reload, Give 'Add Only' Qualifier before LOAD or SELECT Statement
Add Only LOAD * Resident Products Where not Exists(ProductID);
- By using Partial Reload, We can Replace one Table data with another Table Data
- To perform Replace two tables must contain same set of fields
- 'Replace' or 'Replace Only ' Qualifiers before LOAD or SELECT Statement