Interested to Buy Any Domain ? << Click Here >> for more details...
Explain why denormalization is promoted in universe designing?
- 0 Answers
- 905 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between e-r modeling and dimensional modeling?
Explain what is a cube in data warehousing concept?
Explain what is a three tier data warehouse?
what is table partitioning? How it is useful to warehouse database?
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
Explain the different types of data warehousing?
How can we run the graph? What is the procedure for that?
Explain why dimenstion tables are denormalized in nature?
What are various warehousing tools?
Whether dimension table can have numeric value?
Difference between e-r modeling and dimentional modeling?
Why should we use data ware housing and how can you extract data for analysis with example?
Teradata 
