Skip to main content
DD-TRF-003 Complex Joins, Exceptions and Transformation Logic Get the data →
DD-TRF-003-Q050 Very Hard Time series

Incremental load across all batches

Treat the export as the loaded table and the batch files as new arrivals. Append only rows whose TransactionID is not already loaded. How many rows are appended, and what Amount do they add?
Expected
Appended rows and amount, by batch · Bar chart
Tables
FactTransformationEvents, Batch_2025_07, Batch_2025_08, Batch_2025_09 +3 · columns
  • FactTransformationEvents
  • Batch_2025_07
  • Batch_2025_08
  • Batch_2025_09
  • Batch_2025_10
  • Batch_2025_11
  • Batch_2025_12
  • TransactionID
  • Amount

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in