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 8007Post New L&T Interview Questions
Explain about busy waiting?
What are the programs that we can do with the microstrategy architect?
Do sheeps sleep?
Under what condition will read from a terminal return the value 0?
What is uptime?
what do you mean by transfer routines
What does using system mean in c#?
How to write custom sql query in magento?
What is boolean in c?
Can items in a sales order belong to different distribution channels?
If anyone would like to know or practice for FEWA papers contact me on mohamedrashad2@hotmail.com Just completed the supervisor exam in April 2021
For a type a chopper (first quadrant), express the following variables as a function of vs, r and duty cycle in case the load is resistive average output voltage and current?
How can you declare multiple assignments in one statement?
Can you draw DFD?
Without what stage, a recover stage will handle any exception on that page?