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 6738Post New L&T Interview Questions
Explain the configuration process of the managed bean in jsf.
What is document library?
What general group of organic compounds are not oxidesied in the cod test?
Explain planning version
Explain what are the ways to avoid resourceexceptions when sending requests for databaseconnections?
Can we make methods of interface as abstract and final in ooabap ?
How to creating an output value using quicktest professional?
List the differences between observables and promises in angular 2?
How would perform Pattern Matching in C++?
in which situation ion pair require to use?
An atom has 18 protons and 22 neutrons. What is its mass number?
Explain about realization and its relationships?
What is an arp and how does it work?
1)In a pf if we delete a record then how to insert a new record at the same place in that pf?? any logic or code? 2)A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? 3)In which scenario C D I R comes and C D G F comes in a job? 4)If a job came to error while processing a file how we can know at which record the error hit and how to skip that record and process other records without changing program code?
Why do we use jenkins with selenium?