State any 5 of Cods guidelines of an OLAP system, brief
description each?
Answer / naga
Check Dr. E. F. Codd's 12 rules for defining a fully
relational database
Note that based on these rules there is no fully relational
database management system available today. In particular,
rules 6, 9, 10, 11 and 12 are difficult to satisfy.
| Is This Answer Correct ? | 2 Yes | 3 No |
What is the difference between olap and datawarehosue?
What needs to be done when the database is shutdown?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is the difference between view filter and report filter?
What is the "junk dimension"? Give with examples?
Explain what is the difference between power center & power mart?
what is difference between scd2 and scd3
Code the tables statement to produce a multi-level frequency?
Fact table is in normalized or de-normalized form?
What is difference between query studio and report studio?
How to pivot row data using informatica?
Explain the main difference between inmon and kimball philosophies of data warehousing?