----------------Diff b/w Dimensional modeling and
Relational modeling?

Answers were Sorted based on User's Feedback



----------------Diff b/w Dimensional modeling and Relational modeling?..

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

----------------Diff b/w Dimensional modeling and Relational modeling?..

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

Post New Answer

More Cognos Interview Questions

How many reports did you create in your project?

3 Answers   IBM,


can reportnet supports cubes???

4 Answers   IBM, Wipro,


Why cognos scenario is used?

0 Answers  


How to test a cube?

0 Answers  


what is query subject

7 Answers   IBM, TCS,


1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?

2 Answers   IBM,


How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 Answers  


Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,


how to perform single sign in cognos by using url?

0 Answers   IBM,


actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?

1 Answers  


How to test reports in cagonos ?

10 Answers   CST, CTS,


Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,


Categories