bennyaustin.com
Dimension Modeling: The Different Types of Unknown SK
Dimension Tables usually have a member with Surrogate Key (SK) value of -1 to handle unknown members. Unknown SK is usually set when SSIS look-up on a dimension table fails to return a match based …