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 7883Post New L&T Interview Questions
Explain the working of render phase in jsf.
Explain how is the asp.net mvc architecture different from others? : asp.net mvc
What reporting packages are available for SoucreSafe?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What are controls in windows forms?
What is error ora-6502? : BEA Weblogic
What is struts in java?
Explain different ways of creating a thread. Which one would you prefer and why?
How to end the work object in the activity ( method used to kill the work object)?
How do you crop a picture into a shape in powerpoint?
How do you store pictures in a database?
What are the challenging issues you have faced in implementation project/Maintainance project in .net Functionality? How you have overcome that issue?
Do you know what is virtual memory?
How to test if a given string contains a valid number?
Why is technical clearing gl account used?