Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between ODS and Staging
- 4 Answers
- 40570 Views
- HeadStrong, TCS, I also Faced
- E-Mail Answers
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 | 16 No |
Post New Answer View All Answers
what are the different views that are considered when building an object-oriented software system?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
How to pivot data using informatica when you have variable amount of pivot rows?
Explain what are components of report studio?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain what is the metadata extension?
Explain the importance of data warehouse?
I have two universes created by two difference database can we join them in designer & report level? How
What is the difference between connected and unconnected stored procedures?
Explain me what are data marts?
Is there any difference in testing database and data ware housing?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
how much memory space occupied real time project (roughly)?
