# 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.

• 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).

#### 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).

• 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.

#### senkumar79 Profile Answers by senkumar79 Questions by senkumar79

• Oct 4th, 2005

Dimension tables r nothing but a master tables ,thru which u can extract the actual transactions .Dimension table contains less columns and more rows.

#### 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

#### 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).

#### 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.

#### mickey_gupta Profile Answers 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.

#### Anindya1281 Profile Answers by Anindya1281

• Jun 4th, 2011

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