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.

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2057

---

Describe a data warehouse.

915

---

What are the different types of scd's used in data warehousing?

1179

---

Database in use is oracle?

1005

---

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2086

---

Explain what is real time data-warehousing?

1048

---

How many project sources we can create in metadata?

1010

---

For faster process, what we will do with the universe?

941

---

Explain difference between view and materialized view?

893

---

What is data warehouse architecture?

989

---

What are the types of partitioning?

978

---

What is the extension of file to save template?

953

---

Can any one explain the hierarchies level data warehousing.

925

---

Explain what is partitioning? What are the types of partitioning?

905

---

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

924

---