Answer Detail: RE: In which normal form is the dimension table and fact table in the schema?

GeekInterview.com > Interview Questions > Concepts > Data Modeling

Print |

Question: In which normal form is the dimension table and fact table in the schema?

January 01, 2008 21:06:33	#1
canrizt	Member Since: September 2007 Total Comments: 1
RE: In which normal form is the dimension table and fact table in the schema?
Every schema deals with Facts and Dimensions. Fact will be the central table in the Schema were as Dimensions Table are the surrounded table of Fact. Dimensions table is one who give the description of Business Transactions and always having Primary Key . Fact table is one dealing with Measures and having Foriegn Key.