Interested to Buy Any Domain ? << Click Here >> for more details...
State any 5 of Cods guidelines of an OLAP system, brief
description each?
- 1 Answers
- 7149 Views
- I also Faced
- E-Mail Answers
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 |
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
What is the difference between a primary and secondary actor in use case modeling?
Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is the difference between drill through and masterdetail reports?
What is Conceptual, Logical and Physical model?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain clustering algorithm?
Difference between slicing and dicing with example?
What are the vaious etl tools in the market?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Teradata 
