Hi
If you want load new data with out reloading the all other table then go for the partial load
Partial load itself means loading a portion of script
Add Keyword is used to load a table first time.
And if table is already loaded then for loading agin that table we can use below
When executing a partial script reload, all lines are executed except for LOAD and SELECT not preceded by ADD or REPLACE.
- ADD (appends or concatenates the data from one table to another table) wont checks for duplicates, REPLACE (replaces the table or overwrite)
