Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimention?explain dimentable with example?
- 3 Answers
- 9343 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is portal page?
Hi, How the relations will be exists in DMR models if u have any idea please explain me
Name the types of report?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
Interval Prompt's Usage? Example for usage in Project
what is the use of layout component reference
What do you understand by the cognos?
what does my folder and public folder contains? difference between the my folder and public folder?
What is the difference between macro & Parameter
What do you understand by the term 'aggregate cache'?
Where in report Studio's property pane can I find NoDataHandler?
What is called materialized view?
Teradata 
