Data Warehousing - how can you implement many to many relation in star schema model?

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 53 of 92

how can you implement many to many relation in star schema model?

Total Answers and Comments: 3

Last Update: March 09, 2008 Asked by: venkatesh

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 15, 2007 20:29:14

satish

RE: how can you implement many to many relation in sta...

Many-many relations can be implemented by using snow flake schema .With a max of n dimensions .

Is this answer useful? Yes | No

January 25, 2007 05:51:55

gopal

RE: how can you implement many to many relation in sta...

HiUpto my knowlege designers implementing this M-M relation asFirst break the schema to 1-M and M-1 relationsLet me correct if any thing is wrong

Is this answer useful? Yes | No

March 09, 2008 17:09:07

praveen.p

Member Since: September 2007 Contribution: 2

RE: how can you implement many to many relation in star schema model?

Use a bridge table.. as simple as that.

Is this answer useful? Yes | No