Skip to main content
DD-TRF-004 Enterprise Data Transformation and Performance Lab Get the data →
DD-TRF-004-Q048 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
FactDataPipelineEvents, Partition_2025_01, Partition_2025_02, Partition_2025_03 +9 · columns
  • FactDataPipelineEvents
  • Partition_2025_01
  • Partition_2025_02
  • Partition_2025_03
  • Partition_2025_04
  • Partition_2025_05
  • Partition_2025_06
  • Partition_2025_07
  • Partition_2025_08
  • Partition_2025_09
  • Partition_2025_10
  • Partition_2025_11
  • Partition_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.