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
- 7916 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 advantages of cold fusion?
Explain what are the various file formats involved in reportnet?
What is the main difference between inmon and kimball philosophies of data warehousing?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is analytical or analytic mean?
What is the goal of optimizer?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are the steps to build the datawarehouse?
Why denormalization is promoted in universe designing?
Explain what are components of reportnet?
What are the types of partitioning?
Can you pass sql queries in filter transformation?
Explain where do we use semi and non additive facts?
What is bi?
Explain difference between data ware house & data mart?
