What is the difference between full and incremental loading in database sources?¶
During a full load, the entire data is processed on each run whereas during an incremental load, an Audit Field, is specified on the basis of which, the Database source reads the incremented data only. The Incremental and full load options can be found in properties of Database source object. For more information on full and incremental loading options, click here.