Database - Data Warehousing - Discussion

Discussion Forum : Data Warehousing - General Questions (Q.No. 13)
13.
A star schema has what type of relationship between a dimension and fact table?
Many-to-many
One-to-one
One-to-many
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
12 comments Page 2 of 2.

Lalitha said:   1 decade ago
Star schema has structure like star. It has one fact table surrounded by muliple dimension tables connected with that fact table. Thats what the relationship between fact and dimension table is one to many.

Ram said:   1 decade ago
Because you know about the star,Starting from one point towards many point so it is called star Scheme


Post your comments here:

Your comments will be displayed after verification.