Answer Posted / pravin

Operational Data store is a subject
oriented,integrated,current,volatile collection of data
used to support the tactical decision making process for
the enterprise. It is the central point of data integration
for busienss management,delivering a common view of
enterprise data.
In Staging Area you are carried out ETL operations as per
your business logic in order to fetch processed information
into data ware house.

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

933

---

How can we do data cleaning?

988

---

How to generate the cubes in framework manager?

964

---

Explain why denormalization is promoted in universe designing?

908

---

What is the difference between mapping parameter & mapping variable in data warehousing?

930

---

How to add a number to a macro variable?

940

---

Explain how to export mappings to the production environment?

918

---

Why should you put your data warehouse on a different system than your oltp system?

932

---

Fact table is in normalized or de-normalized form?

908

---

Where we use surrogate key explain with example?

1047

---

What is the difference between constraind base load ordering and target load plan?

1060

---

Can you brief about the Data warehouse project you worked on?

2315

---

What are the different problems that ?Data mining? can solve?

2774

---

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

944

---

How can you import tables from a database?

1004

---