Answer Posted / omprakash

It is used to improve the performance of sql query

what are different storage options supported by oracle ?

2140

---

What is cubes?

1111

---

explain about balanced dimension,

1038

---

Explain which are the olap tools available that are supported by oracle?

1052

---

Explain what are the possible data marts in retail sales?

1054

---

What are the design methods of data warehousing?

1006

---

Explain what are slowly changing dimensions?

1075

---

After the complete generation of a report who will test the report and who will analyze it?

1040

---

Explain hybrid slowly changing dimension?

1065

---

What is difference between e-r modeling and dimensional modeling?

972

---

if you use oracle sql*loader , how do you transform data with it during loading?

2144

---

Can a dimension table contain numeric values?

1115

---

What is partitioning? What are the types of partitioning?

1235

---

Which columns go to the fact table and which columns go the dimension table?

1024

---

What are algorithms provided by Microsoft in SQL Server?

2112

---