----------------Diff b/w Dimensional modeling and
Relational modeling?
- 3 Answers
- 15168 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
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 |
Answer / Saurabh Chandra
Dimensional modeling and relational modeling are two different approaches for organizing data in a database. Here's how they differ:nn1. Schemas: Relational databases use a flat schema with no predefined structure, allowing any type of data to be stored together without constraints. In dimensional modeling, data is organized into tables with a specific structure, including fact tables and dimension tables.nn2. Grain: The grain in relational databases refers to the smallest level at which a data entity can be represented. It does not have a fixed definition and may vary depending on the specific use case. In dimensional modeling, the grain is fixed for each fact table and represents the lowest level of detail.nn3. Data Types: Relational databases support all types of data, including structured and unstructured data. Dimensional models primarily focus on supporting data needed for OLAP (Online Analytical Processing) operations, which often include numeric data and date/time attributes.nn4. Query Optimization: Relational databases prioritize fast response times for complex queries using query optimization techniques such as indexing, partitioning, and joins. Dimensional models use pre-aggregated data and materialized views to optimize query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
What you mean by drill across and what is the difference between drill through, drill across?
i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..
what type of charts we create mostly in realtime? plz help
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
What is content store?
if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............
What is power prompts?Can somebody explain me.
Define datastores in cognos?
what is the difference between cascading prompt and drill-thru
explain how to create powerplay reports?
how to test reports in cognos?
Teradata 
