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

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.

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

what about fact table

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.

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