----------------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 |
is there any possibility to hide items other than render variable?
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
what are the limitations of cognos reportnet?
11 Answers IBM, Nestle, TCS,
How to pass parameter value into html design page?
What is the use of powerhouse?
In an existiing Framework model, how will you add a new column to the existing table?
How can I schedule reports in cognos?
what is the difference between aggregation and roll up aggregation?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
When we use consume in cognos?
What are the different types of important services used in cognos?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?