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

Survivorship by latest load

Resolve conflicting TransactionIDs by keeping the row with the latest LoadTimestamp instead of the first occurrence. What is the total Amount in SAR of the surviving table, and how does it differ from first-occurrence survivorship?
Expected
Two totals and the difference · Matrix
Tables
FactTransformationEvents · columns
  • FactTransformationEvents
  • TransactionID
  • LoadTimestamp
  • Amount
Topics
Data Quality

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