Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Newbie design question

  
   Database Forums (Home) -> Data Warehouse RSS
Next:  [Info-Ingres] So many temptations!  
Author Message
Ed

External


Since: Mar 07, 2006
Posts: 33



(Msg. 1) Posted: Tue Jan 29, 2008 3:51 pm
Post subject: Newbie design question
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)
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

 >> Stay informed about: Newbie design question 
Back to top
Login to vote
Charles Wang[MSFT]

External


Since: Jul 17, 2006
Posts: 274



(Msg. 2) Posted: Wed Jan 30, 2008 12:00 am
Post subject: RE: Newbie design question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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-Warehouse-Design-Dimensional/dp/0471324
213
Data Warehouse Design Solutions
http://www.amazon.com/Warehouse-Design-Solutions-Christopher-Adamson/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.
======================================================

 >> Stay informed about: Newbie design question 
Back to top
Login to vote
Ed

External


Since: Mar 07, 2006
Posts: 33



(Msg. 3) Posted: Wed Jan 30, 2008 12:00 am
Post subject: RE: Newbie design question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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-Warehouse-Design-Dimensional/dp/0471324
> 213
> Data Warehouse Design Solutions
> http://www.amazon.com/Warehouse-Design-Solutions-Christopher-Adamson/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.
> ======================================================
>
>
>
>
 >> Stay informed about: Newbie design question 
Back to top
Login to vote
Charles Wang[MSFT]

External


Since: Jul 17, 2006
Posts: 274



(Msg. 4) Posted: Wed Jan 30, 2008 2:00 am
Post subject: RE: Newbie design question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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.
======================================================
 >> Stay informed about: Newbie design question 
Back to top
Login to vote
Charles Wang[MSFT]

External


Since: Jul 17, 2006
Posts: 274



(Msg. 5) Posted: Fri Feb 01, 2008 1:00 am
Post subject: RE: Newbie design question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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.
======================================================
 >> Stay informed about: Newbie design question 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Data Warehouse All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]