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 factless fact tables?
What is meta data and system catalog?
Where we use surrogate key explain with example?
In document how to create metrics?
What are algorithms provided by Microsoft in SQL Server?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is a source qualifier?
What is mean by aggregate aware?
What is the very basic difference between data warehouse and operational databases?
Explain what are the various file formats involved in reportnet?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What is dimensional modelling?
What are the differences between star and snowflake schema?
What is VLDB?
what is difference between drill & scope of analysis?
