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
Explain what are slowly changing dimensions?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
After the complete generation of a report who will test the report and who will analyze it?
What is the difference between star and snowflake schemas?
Explain vldb?
What is batch processing?
How can you set the client management?
What is a fact, dimension, measure?
What is difference macros and prompts?
What is the difference between junk dimension and degenerated dimension?
How to performance tune reports?
explain about balanced dimension,
what are the different views that are considered when building an object-oriented software system?
Explain the definition of normalized and denormalized view?
Explain what are data marts?