Can nullable column (column with blanks) be made into a dimension table?
I have a fact table called ProjectTasks.
How to handle multiple dimension records having the same name even though they have unique key/relation with the fact table (1:M)?
I’m looking at Product dimension table.