Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 7758 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / vignesh
Count(*) will count all records including nulls and count
(column_name) will give count of non-null values only.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the methodologies of data warehousing?
How can you set the client management?
What are fact, dimension, and measure?
What is the difference between olap and oltp?
What is cfapplication tag?
Explain the difference between keylokup and joiner?
Difference between cold fusion mx 6 and cold fusion mx 7?
Where the applications and where ware house management system is used?
Do you view contain data?
What are steps we have to follow in designing the userfriendly universe?
Difference between e-r modeling and dimentional modeling?
How to test report in reportnet?
Explain the main differences between star and snowflake schema?
Explain what are the vaious etl tools in the market?
Explain vldb?
