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

3 Answers   IBM, Ness Technologies,

---

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers   IBM,

---

What is type 2 version dimension?

0 Answers  

---

What are the various methods of getting incremental records or delta records from the source systems?

0 Answers  

---

what is user variable in affinium campaign? and some real time examples.

0 Answers  

---

What is conformed dimension?

6 Answers   Polaris,

---

Explain what is the advantages data mining over traditional approaches?

0 Answers  

---

What is operational data store (ods)?

0 Answers  

---

List any five applications of data warehouse.

0 Answers  

---

When should you use a STAR and when a SNOW-FLAKE schema?

6 Answers   Accenture,

---

What are the other names given to data warehousing?

0 Answers  

---

if we increase the number of dimensions will the rows in fact table increase or decrease??

3 Answers   IBM,

---