When should one use an MD-database (multi-dimensional database) and not a relational one?

2 Answers   IBM,

---

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   L&T,

---

Can a dimension table contain numeric values?

0 Answers  

---

explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

3 Answers   IBM, Ness Technologies,

---

Explain the importance of data warehouse?

0 Answers  

---

What is META DATA information in Data warehousing projects?

2 Answers   IBM,

---

How can you set the session management?

0 Answers  

---

What are the vaious etl tools in the market?

1 Answers  

---

State any 5 of Cods guidelines of an OLAP system, brief description each?

1 Answers  

---

How to create context?

0 Answers  

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

0 Answers  

---

List down some of the real time data-warehousing tools?

0 Answers  

---