----------------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
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
what are the special features in cognos reportnet?
How can I test reports in cagonos?
Can you define report item?
What is called Cognos powerplay?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What is the metric store database?
what is hints in cognos and where we use it.
What is looping and how to avoid it in framework manager?
Why cognos scenario is used?
Can you define metrics designer?
Can you define fan trap?
---------------Tell me about DWH Concepts?
What is meant by alternate drill down with ex?
What do you mean by Drill down and Drill Up?