Difference between ODS and Staging
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.
Is This Answer Correct ? | 28 Yes | 15 No |
Post New Answer View All Answers
How to design file watch jobs?
Explain what is the difference between olap and datawarehosue?
What is is a star schema?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is hybrid slowly changing dimension?
what is an use case?
What is the difference between aggregate table and materialized view?
How can you clear the cache?
What is load manager?
What is the data type of the surrogate key?
What is an error log table in informatica occurs and how to maintain it in mapping?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What are the advantages of raid 1, 1/0, and
Ist the schema that a data warehouse system can implements.
Explain is olap databases are called decision support system true/false?