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 7922Post New L&T Interview Questions
Highlight the facilitating and/ or inhibiting factors
You are the project manager for a web development project. You hold regular project status meetings and publish status reports on a timely basis. You know that communication is one of your most important functions. As such, all of the following are true except: A. Senders are responsible for sending clear, concise, complete messages. B. Receivers are responsible for understanding the message. C. Communication can be vertical or horizontal or both. D. Effective communication techniques include making eye contact, nodding, and asking clarifying questions.
write a program that will open the file, count the number of occurences of each word in the the complete works of shakespeare. You will then tabulate this information in another file.
What do you understand by linear regression and logistic regression?
How do you use compareto in java?
How to configure a DB connection pool ?
Mention what are some bad examples of web design?
What is orm tool in hibernate?
please briefly explain calculating or estimating steel quantity for a RCC column?
What is logical database? : abap hr
What are the rules to implement connection pooling?
Are arrays dynamic in java?
What is the directory structure of rails?
What is the keyboard shortcut for closing a presentation?
Differentiate between .py and .pyc files?