SEO

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

Hi Ed,
I recommend that you create two dimensions here, one for Consultant, one
for Customer, though currently they are one to one. Flexibly considering
one day for some special cases, you need to assign two or more consultants
to your customer. In this case, you need not do anything if you have
separated them to two dimensions.

I would like to recommend two books for you:
Mastering Data Warehouse Design: Relational and Dimensional Techniques
http://www.amazon.com/Mastering-Data...nal/dp/0471324
213
Data Warehouse Design Solutions
http://www.amazon.com/Warehouse-Desi...damson/dp/0471
25195X

Hope this helps. Please feel free to let me know if you have any other
questions or concerns.

Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Thanks Charles. I understand designinig a good dw is always a challenge. I
seem to remember I read a book about avoiding creating too many dimensions
and that's why I am confused.

"Charles Wang[MSFT]" wrote:

> Hi Ed,
> I recommend that you create two dimensions here, one for Consultant, one
> for Customer, though currently they are one to one. Flexibly considering
> one day for some special cases, you need to assign two or more consultants
> to your customer. In this case, you need not do anything if you have
> separated them to two dimensions.
>
> I would like to recommend two books for you:
> Mastering Data Warehouse Design: Relational and Dimensional Techniques
> http://www.amazon.com/Mastering-Data...nal/dp/0471324
> 213
> Data Warehouse Design Solutions
> http://www.amazon.com/Warehouse-Desi...damson/dp/0471
> 25195X
>
> Hope this helps. Please feel free to let me know if you have any other
> questions or concerns.
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
>
> ================================================== ====
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
>
>

Hi Ed,
Avoiding creating too many dimensions for a fact table is true since too
many dimensions will impact the performance of the upper level analysis. I
could just give you some directions here. My recommendation is that before
you encounter any performance issue, do not consider much of it. After you
finish your design, review your design map to see if there are too many
dimensions (over 10 dimensions for one fact table?). It is always a best
practice if you could establish a test environment for validation. After
that you can conclude if you need to optimize your design.

Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Hi Ed,
Just a kind reminder, I have not received your response. Please feel free
to post back at your convenience if you need further assistance.

Have a great day!

Best regards,
Charles Wang
Microsoft Online Partner Support

PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.
We also love to hear your product feedback!

Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====