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 7911Post New L&T Interview Questions
What is thread pooling?
Can you tell me limit of character used for PPC Ads ?
What is gii? Why it is used?
How does it differ from traditional computing architectures?
How many types of emergency landings are there and explain?
How do I search multiple files in windows?
convert 140 N.m/cm^2 to N.m/mm^2
Which query language is used for neo4j?
Is azure a cloud service?
Explain the uses of jsp?
Can we override the static methods?
What are Importers in WordPress?
What can the rpa not do?
What is the fact table?
What are infectious diseases? How are they spread?