what is dimention?explain dimentable with example?

Question Posted / mkreddy

3 Answers
8200 Views
Syntel, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is dimention?explain dimentable with example?..

Answer / sunitha

Dimensions are categories by which summarized data can be
viewed.
A dimension table is a table that contain summarized
data and historical data.The dimension table has foreign key
- primary key relation with fact table.

Is This Answer Correct ?

6 Yes

2 No

what is dimention?explain dimentable with example?..

Answer / palzkumar

Dimension Table is a table which contains categories and
hierarchies with lowest granule.
Data stored in dimension are nothing but the masters.
Its doesn't store any numeric value or summerised data.

eg.
Product dimension
Customer dimension
Channel dimension
Time dimension
etc..

Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-sep-08
2009 > Qtr-02 > Aug > 35 > 05-sep-08
2009 > Qtr-02 > Aug > 35 > 06-sep-08

rgds
palz

Is This Answer Correct ?

4 Yes

2 No

what is dimention?explain dimentable with example?..

Answer / palzkumar

sorry...

pls read date aug i/o sept

Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-aug-08
2009 > Qtr-02 > Aug > 35 > 05-aug-08
2009 > Qtr-02 > Aug > 35 > 06-aug-08

Is This Answer Correct ?

1 Yes

4 No

Post New Answer