----------------Diff b/w Dimensional modeling and
Relational modeling?
- 2 Answers
- 13913 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chiranjeevi
Relational modelling:
Data modelling of transactional systems
Dimensional modelling:
Data modelling of decision support
systems
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / pooja
Dimensional Model:
A denormalized relational model made up of tables with
attributes. Relationships defined by keys and foreign keys
Organized for understandability and ease of reporting rather
than update Queried and maintained by SQL or special purpose
management tools. Optimized for retrieval, the data
warehousing model.
Relational Model:
The Transaction Processing Model that Minimize data redundancy
since it is normalized.
Disclaimer: This posting is provided AS-IS with no
warranties or guarantees and confers no rights.
| Is This Answer Correct ? | 4 Yes | 1 No |
what is reprompt?
Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.
i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)
Sales person are there in one company How to do Bursting on this particular requirement?
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
What is the difference between a cascading report and drill through the report?
-------------What is a Conformed Dimension?
What is the importance of having monitor service in cognos?
how will optimiz the performance of sql in FM ?
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
Teradata 
