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 what are the basic needs to join two sources in a source qualifier?
What are vaious etl tools in the market?
What are the steps involved in designing a fact table?
Explain what is ods (operation data source)?
Ist the schema that a data warehouse system can implements.
What do you mean by static and local variable?
Explain me what are conformed dimensions?
What are the types of partitioning?
Explain hybrid slowly changing dimension?
What is ods (operation data source)?
Explain what are the different types of join operations?
Explain what are slowly changing dimensions?
Explain what are the advantages data mining over traditional approaches?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?