Answer posted by Riaz Ahmad on 2005-06-09 14:45:26: A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes.

Read Best Answer

Editorial / Best Answer

Answered by: Edmond

• Apr 13th, 2007

---

Let's be very clear. this is a very simple, and becomes a very confusing subject.
A fact table is an entity representing the numerical measurements of the business. A dimension table is the entity describing the textual representation of the business.

In a banking model, the account and balances are the measurements within the fact table, where customer name, social security, address, time period of the account, are the dimensions (customer/time).

Hope this answers the clarification.

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• Jun 5th, 2011

In very simple termsFact : this contains all numeric attributesDimesion : this contains all non numeric , textual attributesIn order to rememberFact : Any answer to What user want to see is factfor ex...

mickey_gupta

 Profile Answers by mickey_gupta Questions by mickey_gupta

• Mar 4th, 2009

Dimension table contains reference data which gives meaning to fact data. You can also view them as parameters across which you want to analyze the fact data.

Improve Answer