Interested to Buy Any Domain ? << Click Here >> for more details...
----------------Diff b/w Dimensional modeling and
Relational modeling?
- 2 Answers
- 14870 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 |
What is the difference between a cascading report and drill through the report?
what is Governor settings in cagnos?
Can you define report item?
what is a query subjects item?
What are the roles defined by cognos platform?
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
I have to apply drill through 1,2,7 out of 10 in order method, how can i do?
Write types of folders present in cognos?
what was the actual purpose of portfolio in cognos ?
what is an associated query?
write a query to display to 10 max record from the employee table?
Teradata 
