You have a source table with orders updated throughout the day, and you need to load it into a warehouse every hour. How would you design an incremental load so that new and changed rows are captured correctly without reprocessing the full table each time?
Write your answer in the field below and click the "Check answer" button.
The AI feedback on your answer will appear here.