Full vs Incremental Loading

Concepts: paFullVsIncremental

What They Want to Hear 'Full refresh drops the entire table and reloads from scratch. Incremental only processes rows that changed since the last run. I default to incremental because it is faster and cheaper, but I run a full refresh weekly as a safety net.' That is the answer. Two strategies, a default choice, and the safety valve.