Data Modeling Puzzle

1234567891011121314151617
Across
  1. 3. Structured information that defines and describes other physical data assets.
  2. 4. Data Vault table storing descriptive context and historic changes over time.
  3. 6. An artificial unique identifier with no business value used to join tables.
  4. 8. Data Vault table containing only unique business keys and loading metadata.
  5. 10. Data Vault table representing associations or transactions between business keys.
  6. 13. An intermediate table used to resolve many-to-many dimensional relationships.
  7. 14. Dimensional schema where out-of-core dimension tables are fully normalized.
  8. 16. A dependency where attribute A determines B, and B determines C.
  9. 17. The pathway tracking data from origin source to target presentation destination.
Down
  1. 1. The lowest level of detail represented by a single row in a fact table.
  2. 2. In lakehouses, the Bronze, Silver, and Gold structured data organization layers.
  3. 5. A dimension attribute stored directly in the fact table without a join key.
  4. 7. A satellite containing multiple active records per business key at one time.
  5. 9. A satellite tracking the active start and end dates of link relationships.
  6. 11. An insert-only satellite designed to track transaction history without end dates.
  7. 12. Dimensions that share exact identical meaning and values across different facts.
  8. 15. Table designed to optimize asynchronous satellite joins by tracking active keys.