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 7771Post New L&T Interview Questions
How to read files and process BDC's automatically ?
Which js framework is best with laravel?
What type of charts did you used?
Which functions are used to count the total number of array elements in php?
I renders interior Services, consider one project cost Rs.500000/- Scenario 1 - Material purchased on my Firm Name Material - 300000 -300000 On party behalf Labour - 200000 -150000 My expenses for Labour Contracts Profit - 50000 My Profit Scenario 2 - Material purchased by client Labour - 200000 -150000 My expenses for Labour Contracts Profit - 50000 My Profit In both Profit is same Rs. 50000/-. which is beneficial for me in terms of turnover or tax matters. and if I have to raise a bill to party as per both scenario, how it will affect bill and tax, where will I suffer loss?
How do I disallow NULL values in a table?
Do stored procedures prevent sql injection?
How can a user confirm whether sap html control is utilized or not?
There is a kind of animation that using an xml file to define a sequence of pictures using?
How do I do a system restore if windows won't start?
How to convert a binary number into bcd number directly and vice-versa, without converting it into any other number system?
What is session setattribute?
Whether the output of mapper or output of partitioner written on local disk?
Where is update field in word?
please tell me croscarmellose sodium usp Water-soluble substances calculation and give me exmpl