----------------Diff b/w Dimensional modeling and
Relational modeling?
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 are differences between Reporter report and Explorer report?
What is the use of Generated Prompt? Where is it used in realtime project?
wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?
im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?
How can I test reports in cagonos?
How to hide/unhide the prompts which are not used by unauthorized users?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Diff b/w Crossproduct and Outerjoin?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
Explain how data modeling is useful to cognos in daily life?