Interested to Buy Any Domain ? << Click Here >> for more details...
----------------Diff b/w Dimensional modeling and
Relational modeling?
- 2 Answers
- 14865 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
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 all the types of report?
what are the errors faced while bursting the reports and how to solve those errors?
What is the use of powerhouse?
Can you define folder?
Can you explain a cognos controller?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What are the types of catalogs in cognos?
Can you define bitmap index?
Why cognos scenario is used?
Define olap designer?
What is the difference between ‘macro’ and ‘prompt?
how you create security to reports?
Can you define dimension?
What is difference between informatica power mart and power center?
