My dimension table X has primary column as Primary_ID as char(3) column. About 90% of rows in my dimension has value 'Not assigned' and such rows are scattered in table.
I have added one column as OLAP_ID to dimension table X which will assign default '000' value to all 'Not assigned' rows. This will group together all invalid rows.
Fact table has Primary_ID as FK.
I have following questions:
1. Which column should be use as key column in my dimension table.
2. What should be the hierarchy between Primary_ID and OLAP_ID column.
Let me know if you need more details.
View Complete Post