----------------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 |
which difficult you faced in your project?
What is a Datastore in Cognos?
What do you understand by the term 'dynamic cube'?
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?
what is cube size?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What are the advantages of shortcuts?
What are initial page components of Cognos connection?
what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
advantages of cascade prompt ???
please please give me some banking calculations in framework manager.