@sathyan75 I've consulted the engineering team here and they confirmed that a full load is required in case you changed a table by adding or removing columns. That's by design to guarantee data consistency.
@sathyan75 there're two folds to your question. Changes in records and changes in columns.Changes in Records (columns are unchanged):Incorta won't purge the old records if you do incremental loads. But if you trigger a full load Incorta will discard ...