Hi,
I am new to the dw and I have a stupid question.

Our company has a Consultant assigned to each Customer. When I design the
Dimension tables, how do i determine if i need two tables, one for
Consultant and one for Customer or just simply add the Consultant Name into
the Customer Dimension table without creating an extra Consultant Dimension.
it looks like to me that with / without Consultant table, I can still easily
get the total number of sales by Consultant. I am not sure what is the best
way or any rule to follow.

Thanks

Ed