SNK - option to discard making a key when a business key is null

When a business key in a fact table is null I would not like to have an SNK key created as the SK but instead, set it as -1, that is the global value for a non-existing value in my data warehouse.


Please sign in to leave a comment.