1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / arkchowdary

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

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,

What is the difference between cognos 8.2 and cognos 8.3?

5 Answers  

what happens when date function has taken as attribute

1 Answers   TCS,

----------------What is meant by DSS?

1 Answers   Bank Of America,

----------0Diff b/w Report Functions and Database functions?

1 Answers   IBM,




How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?

1 Answers   Polaris,

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

what is the different between primarykey and surrogated key.. why we are going for surrogatekey...

1 Answers  

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

0 Answers   IBM,

what is the difference between Cognos EP7 series and Congos8?

2 Answers   Hexaware,

what is dash board?

2 Answers   Syntel,

what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?

1 Answers   Dr Reddys, TCS, Thomson Reuters,

For more Cognos Interview Questions Click Here
Categories