Clear all

Key management in Information Marts

Posts: 0
Topic starter
Joined: 51 years ago

What's the right/recommended way to manage keys for the (dimensional) information mart?
The book mentions a Type 2 Dimension should have the hash of the BK and SnapshotDate as Key, but this means it differs from the hash done while building a fact (BK and Start Date of a Satellite).
IMHO, you can do the hash of a T2 dimension on a PIT table (or use a sequence) and then use the same PIT to lookup the keys for a fact with a between clause on the join between the Link(s) (or Bridge(s)) and the PIT?

7 Replies