----------------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 are the considerations regarding performance kept in mind while setting up cognos?
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
---------------What is Dimension?
write a query to display to 10 max record from the employee table?
What is meant by drill down?
Can you define drill across?
When we save a report in report studio with what extn it save?
wt is tupple , Embed function ? wt is regular dimension ?
How to pass multiple values from picklist prompt to sub report filter?
. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.
------------------- What is Busschema?