What is a dimension table


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.

Editorial / Best Answer

Answered by: Edmond

  • Apr 12th, 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.

Showing Answers 1 - 6 of 6 Answers

deepak

  • Jun 5th, 2005
 

A dimesion table in datawarehouse is one which contains primary key and attributes.we called primary key as DIMID's(dimension id's).

  Was this answer useful?  Yes

Riaz Ahmad

  • Jun 9th, 2005
 

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.

SENTHIL KUMAR B

  • Feb 13th, 2006
 

Dimensional table is a table which contains business dimensions thru which v analyse the business metrices

sunil

  • Aug 8th, 2006
 

dimension table contains normalized data

what about fact table

  Was this answer useful?  Yes

Edmond

  • Apr 12th, 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.

jyotsna

  • Jul 1st, 2007
 

A dimensional table contains detail values/data which is short and wide(ie; less coloums and more rows)
Always based on dimensions analysis is done in Datawarehousing.

  Was this answer useful?  Yes

In very simple terms

Fact : this contains all numeric attributes
Dimesion : this contains all non numeric , textual attributes

In order to remember

Fact : Any answer to What user want to see is fact
for example user want to see profit,sale,amount

Dimesion : Any answer to HOW or By is dimesion
how they want to see profit
by region,sales person,time

note : the above explanation is not 100% true but works in most of cases and can be used by new DWH user as tips

thanks

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions