Answer Posted / shribhagwan

1 Because More than one dimensions can be shareble for Other
Department

2 The Physical Load will be less.

3 Less Complexity of Fact

What are the different types of segments?

933

---

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1013

---

What is the difference between view materialized view and view?

1042

---

Explain reference cursor?

2135

---

Explain what are the methodologies of data warehousing?

892

---

What are non-additive facts in detail?

945

---

Start a batches with in a batch?

949

---

Explain what are the basic needs to join two sources in a source qualifier?

1062

---

Explain what are the various reporting tools in the market?

936

---

What are the data types present in bo? What happens if we implement view in the designer n report?

906

---

What are the fundamental elements of the data warehouse?

957

---

Explain how to export mappings to the production environment?

941

---

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

876

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

985

---

What are session timeout and application timeout?

985

---