Answer Posted / harshad

An operational data store (ODS) is a type of database often
used as an interim area for a data warehouse. Unlike a data
warehouse, which contains static data, the contents of the
ODS are updated through the course of business operations.
An ODS is designed to quickly perform relatively simple
queries on small amounts of data (such as finding the
status of a customer order), rather than the complex
queries on large amounts of data typical of the data
warehouse. An ODS is similar to your short term memory in
that it stores only very recent information; in comparison,
the data warehouse is more like long term memory in that it
stores relatively permanent information.

But in staging we are storing current as well as historic
data. This data might be a raw and then need cleansing and
transform before load into datawarehouse.

What is the difference between static cache and dynamic cache?

1060

---

Name a few sectors which use data warehousing?

984

---

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

967

---

How to know the time taken for particular report execution?

1006

---

What is the main difference between star and snowflake star schema? Which one is better and why?

1080

---

What are algorithms provided by Microsoft in SQL Server?

2109

---

What is the difference between agglomerative and divisive hierarchical clustering?

1245

---

What is degenerate dimension table?

1050

---

Is there any rownum object from which we can do this?

987

---

Briefly state different between data ware house & data mart?

1085

---

What is factless fact tables?

1285

---

Explain what is the difference between power center & power mart?

1047

---

Explain what are the different types of data warehousing?

1005

---

Explain if a flat file cotains 1000 records how can I get first and last records only?

966

---

Suppose we want to display zero when null values coming to report how can we do that?

982

---