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 6758Post New L&T Interview Questions
Hi Experts, Have you worked on IDOC’s? Can you list out important t-codes in IDOC’s and their brief explanation for what they are used for in general and specific t-codes which are useful for SAP SD Module? I have interview within 1-2 days? So, I request you to provide solutions to above question as early as possible? Your timely help would be greatly appreciated? Thanks in advance Regards
Can excel be used as a relational database?
Explain the term minimum length & width.
Does anybody used Visio in QA.If so, can u please explain where and when u used visio diagrams
What are different types of verifications?
What does sort () do in python?
How can I recover data from undetected hard drive?
What inheritance is and an example of when you might use it?
How do you capture tooltip using QTP?
Write my own zero-argument manipulator that should work same as hex?
Can we change the layout of miro screen? Does it require enhancement?
In the creation of the material master if user maintains MRP Type as ‘VB’ (Manual reorder point planning) unless until user will not maintain the Reorder point Qty & fixed lot size Qty system will not allow creating the material which is right process. Hence the same rule should be applied for MRP Type ‘ND’ also. So that user cannot fill the MRP Data unless he will not choose ‘VB’
What is crud generator?
How do I find a file path on a mac?
Pls explan the OLR setting in VCB at HT yard