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

Rows breaking the exception rules

Join the cleaned export to RuleExceptions by canonical Category. How many rows exceed MaxQtyPerLine, and how many have an Amount in SAR above RequiresApprovalAboveSAR?
Expected
Two counts and the flagged rows · Exception table
Tables
FactTransformationEvents, DimProduct, RuleExceptions · columns
  • FactTransformationEvents
  • DimProduct
  • RuleExceptions
  • Quantity
  • Amount
  • Category
  • MaxQtyPerLine
  • RequiresApprovalAboveSAR
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