Interested to Buy Any Domain ? << Click Here >> for more details...
What are the approaches used by optimizer during execution plan?
- 0 Answers
- 961 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
List any five applications of data warehouse.
Explain what is a view as it relates to system modeling?
What are target types on the server?
Explain hybrid slowly changing dimension?
Explain in detail abt measure objects? And what is the use of it? How to create it?
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 what is ods (operation data source)?
Explain what are non-additive facts?
What is mapplet?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Why should you put your data warehouse on a different system than your oltp system?
Teradata 
