----------------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 is reprompt?
when can i use the STAR Schema and SNOWFLAKE Scgena
What are the components required for the application tier?
can you apply grouping on crosstab?
What is metric studio?what is score cards and how to implement score cards what is the use of score card?
What are the methods by which it non-durable model could be changed into the durable model?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
Can you define cube?
tell me the creation of Snapshots?
What is called Cognos powerplay?
-------------What is Coditional Prompting?