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?
Discussion:
12 comments Page 1 of 2.
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.
Rajkumar said:
1 decade ago
The star schema gets its name from the logical model's resemblance to a star with a fact table at its center and the dimension tables surrounding it representing the star's points. Thus as said above its nothing but one to many.
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.
K.padma said:
1 decade ago
Star schema as the name itself insist that it has an structure like star so it has an fact table at the center and it has relationship with other dimension.
Surya said:
1 decade ago
Facts are the core data elements being addressed/analyzed using the foreign key. Dimensions are attributes about the fact using primary key.
Ponsaravanan said:
1 decade ago
Its a easiest question, the definition of star schema itself says that it was an one-to-many relationship.
MAHALAKSHMI said:
1 decade ago
In star schema we have only one fact table and more dimension table. So the relationship 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
Meena said:
1 decade ago
A star schema can contain multiple fact tables. One fact tables are conned with many dimension.
Prathi said:
1 decade ago
Because there will be one fact table and surrounded by many dimension table.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers