Answer Posted / guest
An Operational Data Store (ODS) integrates data from
multiple business operation sources to address operational
problems that span one or more business functions. An ODS
has the following features:
• Subject-oriented — Organized around major subjects
of an organization (customer, product, etc.), not specific
applications (order entry, accounts receivable, etc.).
• Integrated — Presents an integrated image of
subject-oriented data which is pulled from fragmented
operational source systems.
• Current — Contains a snapshot of the current
content of legacy source systems. History is not kept, and
might be moved to the data warehouse for analysis.
• Volatile — Since ODS content is kept current, it
changes frequently. Identical queries run at different
times may yield different results.
• Detailed — ODS data is generally more detailed than
data warehouse data. Summary data is usually not stored in
an ODS; the exact granularity depends on the subject that
is being supported.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is a fact, dimension, measure?
What is the working process for application.cfm?
Explain about core dimension, balanced dimension, and dirty dimension?
What are the different models used in cluster analysis?
Why should you put your data warehouse on a different system than your oltp system?
Explain what are data marts?
Explain the difference between dw and bi?
Explain where do we use semi and non additive facts?
How can you communicate with web server (apache or iis) from coldfusion?
What is the difference between data warehouse and operational systems?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the advantages data mining over traditional approaches?
What are the advantages and disadvantages of reporting directly against the database?
What are the design methods of data warehousing?