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
- 6739 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
How to generate the cubes in framework manager?
What are the different types of data warehousing?
What is scd1 , scd2 , scd3?
I need to set predefined condition. How I do this?
What is the function of surrogate key in data warehousing?
How to pivot data using informatica when you have variable amount of pivot rows?
How to calculate fact table granularity?
Why we use repository connectivity?
what are relationships?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain what are the different methods of loading dimension tables?
How to design file watch jobs?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain what is a three tier data warehouse?
