Skip to main content
Data Dare data transformation L3 sticker: the findi360 mascot analysing Complex Joins, Exceptions and Transformation Logic.

DD-TRF-003

Complex Joins, Exceptions and Transformation Logic

Decide which customer tier a sale belonged to on the day it happened, which rows break the exception rules, and what survives duplicate resolution.

  • Data Transformation
  • L3 · PARQUET
  • ~514,953 rows
  • 12 tables
  • 50 questions
Get the data 50 questions

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-TRF-003_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-TRF-003_Data_Dictionary.xlsx 12.7 KB · v1.0
  • Business Introduction PDF DD-TRF-003_Business_Introduction.pdf 614.4 KB · v1.0
  • Relationship Diagram PDF DD-TRF-003_Relationship_Model.pdf 615.5 KB · v1.0
  • Raw fact data DD-TRF-003_FactTransformationEvents.parquet 12.6 MB · v1.0
  • Dimension / supporting data DD-TRF-003_Dimensions.zip 1.1 MB · v1.0

Questions

Open one to discuss it
  1. Q043 Very Hard Checksum of the final table
  2. Q044 Very Hard Conflicting duplicates: amount at stake
  3. Q045 Very Hard Survivorship by latest load
  4. Q046 Very Hard Customers collapsed by alias mapping
  5. Q047 Very Hard Sales re-tiered by the SCD change
  6. Q048 Very Hard Schema drift in batch Batch_2025_09
  7. Q049 Very Hard Schema drift in batch Batch_2025_12
  8. Q050 Very Hard Incremental load across all batches

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

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

Create a free account Sign in