----------------Diff b/w Dimensional modeling and
Relational modeling?
Answer Posted / 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 View All Answers
What are the methods by which it non-durable model could be changed into the durable model?
How to deploy from one server to another server?
Can you explain a cognos controller?
What are the components used in web tier?
What are types of batch available in cognos?
Can you explain cognos planning?
What is the enterprise class platform architecture of cognos 8?
what is the main advantage of impromptu over cognos reportnet?
What are the components of the report studio?
--------------Diff b/w ODS and OLAP?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
Can you define slice?
What are the types of studio present in Cognos?
What is the difference between a cascading report and drill through report?
What is a Query Subject?