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 are the steps of implementing data warehousing?
Explain difference between view and materialized view?
What is Cognos script editor?
Briefly state different between data ware house & data mart?
How to improve session performance in aggregator transformation?
Explain what are the advantages data mining over traditional approaches?
What is the main difference between star and snowflake star schema? Which one is better and why?
How to create prompts in report net?
What a static and local variable?
What is the difference between power center & power mart?
Explain what are components of report studio?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain the different types of data warehousing?
Tell me what is full load & incremental or refresh load?
Explain how are the dimension tables designed?
