----------------Diff b/w Dimensional modeling and
Relational modeling?
- 2 Answers
- 13881 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 |
Can you define a datastore in cognos?
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
6. Which of them will increase the performance?
9. What was the most complex type of report you dealt with?
In a Single page we are having 3 list. While running each has to populated in separate page?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Can i apply drill through on master detail relationship report?
What is an olap designer?
what is an sid (surrogate key)?
-------------What is Coditional Prompting?
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
data import to models, datastores,stored processed, is there any other way to import data?
Teradata 
