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
- 7901 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
in general which algorithms for used?
Explain what are the advantages of query studio compared to report studio?
can anybody mail me the FAQS for hyperion essbase amd planning
What is latest version of power center / power mart?
Explain vldb?
Explain what are non-additive facts in detail?
Explain what is analytical or analytic mean?
What needs to be done when the database is shutdown?
Explain what are the different types of data warehousing?
What is a data warehousing?
What is the difference between agglomerative and divisive hierarchical clustering?
Explain what are the different methods of loading dimension tables?
Explain what is data validation strategies for data mart validation after loading process?
How are models actually derived?
Compare cold fusion with other programming languages?
