Skip to main content
DD-HRM-005-Q003 Medium

Pay codes missing from the catalogs

How many distinct pay codes are posted in FactPayResult but appear in none of the three pay-code catalogs? Compare each company's lines with its own catalog.
Expected
One whole number · KPI card
Tables
FactPayResult, DimPayCode_SAP, DimPayCode_ORA, DimPayCode_LEG · columns
  • FactPayResult
  • DimPayCode_SAP
  • DimPayCode_ORA
  • DimPayCode_LEG
  • PayCode
  • EntityCode

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. Need help? Message us