Answer Detail: RE: What is Dimensional Modelling

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: What is Dimensional Modelling

May 05, 2005 21:01:55	#1
Nirav	Member Since: Visitor Total Comments: N/A
RE: What is Dimensional Modelling
In Dimensional Modeling, Data is stored in two kinds of tables: Fact Tables and Dimension tables. Fact Table contains fact data e.g. sales, revenue, profit etc..... Dimension table contains dimensional data such as Product Id, product name, product description etc.....