what is dimention?explain dimentable with example?
- 3 Answers
- 8800 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 |
Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com
How we check the errors before running the report,plz let me know the answer
How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.
how u migrate the reports from impromptu to reportnet???
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
What are the types of studio?
how can you set the image in the report
hi friends pls forward impropmtu interview question
What are the services provided in cognos 8?
What DB View and Bus View?
Explain the characteristics of cognos?
If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09
Teradata 
