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
Explain is fact table?
Describe a data warehouse.
Explain what are the steps to build the data warehouse?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What are the key columns in Fact and dimension tables?
What are aggregate transformation?
How to know the time taken for particular report execution?
Explain what does level of granularity of a fact table signify?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What is ods (operation data source)?
What is a data profile?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain grouped cross tab?
Explain how to export mappings to the production environment?