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 7245Post New L&T Interview Questions
Usually we mention T or O in CONFIRMATION TYPE. What is T and O , stand for ?
Whether 3 phase induction motorwith 100 hp capacity , Amp 160 for which sensitive earth fault relay , type CTUM 15 can be used?
Explain file precedence in splunk.
What are 5 vs of big data ?
What are the uses of task editor filters in dubugging task?
Mention what is the best way to copy files between hdfs clusters?
How do I create an xml file format?
What is ado.net in vb net?
What is package in cobol db2?
WHAT IS DIFFERENT BETWEEN YOU AND OTHER APPLICANT TO GIVE YOU THE JOB
Define thin client?
What is representational state transfer (rest) in angularjs?
Explain what is free fall acceleration?
Explain the difference between bias and variance?
What proportion will you adopt while making allotments to advertisements and promotions from the total budget for marketing?