Hi,
I was wondering something but I can't find it in Kimball's books... If I have two facts that make use of the same dimension 'product', would I have one dimension 'product' or one dimension per fact table so that I can maintain them separately? I can see how this can be a pain in ETL to have to deal with another dimension but at the same time, if I only need to store 1 attribute for one fact table vs. 5 for another one it would (sort of) make sense no?
I'm curious to see how people handle this type of design questions.
Thanks,
Greg
I was wondering something but I can't find it in Kimball's books... If I have two facts that make use of the same dimension 'product', would I have one dimension 'product' or one dimension per fact table so that I can maintain them separately? I can see how this can be a pain in ETL to have to deal with another dimension but at the same time, if I only need to store 1 attribute for one fact table vs. 5 for another one it would (sort of) make sense no?
I'm curious to see how people handle this type of design questions.
Thanks,
Greg