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
2 6771Post New L&T Interview Questions
What does ng controller do?
What is screen object in JavaScript?
What is an undeniable signature scheme ?
Can I reinstall wordpress without losing content?
What is a category in objective c?
what is the difference between Tabular and Matrix report?
Could any one tell me "How can i recognize my cursor position using QTP 9.2" Give me a scripts for this
Define personal connection?
WHAT ARE THE VARIOUS METHODS TO REDUCE INVENTORY? IN OUR COMPANY WE ARE HOLDING A LOT OF DEAD STOCK, KINDLY GUIDE/SUGGEST ME HOW TO GO ABOUT IT?
Explain circular linked list?
explain your project plan with exam pal? i am preparing inter view .............
What is commit?
How many looping constructs are present in go programming language?
who are the maincustomer of a personnel department and which two qualities are important for those working there to display if it is fulfil its purpose?
Explain mandatory property of app.engine?