Fact and dimensions

Hi, the relation between Fact to Dimension is one to Many.

fact to dimension is
fact is Many
dimension is one
so many to one

One Fact table, many dim tables in a star schema

Hence Fact to Dimension is many to One

in the data ware house, the relation between fact and dimension table is , in the dimension the relationship is ONE -TO--ONE, and in the fact that is ONE-TO-MANY,SO THE QUERY PROCESSING TIME WILL BE LESS WHEN WE MAINTAIN THAT RELATIONSHIP BETWEEN FACT AND DIMENSION TABLE

@mulogiri, sorry youre wrong bro, how come a fact table which has more records and lesser column to be many to one to a dim table which usually has more columns and lesser records. Youre really wrong in database concept.

Fact table : contains numerical data to get measures of business : Foreign relation to dimension table values

Dimension table : contains descriptive data like region name , country name ..Primary key values will be there

Fact to dimension is many to one...for one dimension record, you will see many fact records associated

For one dimension record, you will see many fact records associated.Many to one or one to many relationship is not to be confused with number of records or columns in a table. that has nothing to do with a relation