Change Junk Dimension Key Data Type

Currently, junk dimension tables are automatically keyed with varbinary 64 fields.  This takes up a lot of room in a fact table and can’t be used as a join in Tabular.  Can junk dimensions share the functionality of the supernatural key stores by storing the hash locally, and using an integer as a key instead?


Please sign in to leave a comment.