Answer Posted / sj

2. Bitmap indexes
3. partitioning
4. ranking

What are the different types of datawarehosuing?

559

---

Explain when do we analyze the tables? How do we do it?

610

---

what is an use case?

624

---

what are different storage options supported by oracle ?

1606

---

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

504

---

---

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

1575

---

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

602

---

What are snapshots? What are materialized views & where do we use them?

523

---

What is incremintal loading?

575

---

What is data analysis? Where it will be used?

556

---

What is the data type of the surrogate key?

537

---

What is the use of tabular model, tabular sql, tabular reference in real time application?

514

---

How are the dimension tables designed?

565

---

Explain er diagram?

553

---

What is the use of incremental aggregation? Explain me in brief with an example?

583

---