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 surrogate key? Where we use it? Explain with examples.
How to create context?
What are templates in which way it is help full?
What is drill-through?
How to create different types of templates?
What are the reasons to use a chameleon method in data warehousing?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
How to create prompts in report net?
Explain some of modeling tools available in the market?
What is power play plug in?
How can we run the graph? What is the procedure for that?
How to join 3 database like flat file, oracle, db2 in informatrica?