IndiaBIX

Database - Data Warehousing - Discussion

Discussion Forum : Data Warehousing - General Questions (Q.No. 13)
Data Warehousing
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.
Meena said:   1 decade ago
A star schema can contain multiple fact tables. One fact tables are conned with many dimension.
Nayeem FS said:   1 decade ago
Star schema is a combination of fact & dimensions. Fact tables contains fore data elements being analysed whereas dimension tables consists of attributes of the facts and so one fact tables are connected with many dimension tables.
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers