What is operational data source (ODS)?
Answers were Sorted based on User's Feedback
Answer / 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 |
It is a collection of integrated databases designed to
support operational monitoring. Unlike the OLTP databases
the data in the ODS are integrated, subject oriented and
enterprise wide data.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is a Data Warehouse?
How to drill through from a powerplay cube to reportnet?
What are the design methods of data warehousing?
Explain the definition of normalized and denormalized view?
Explain what is the difference between power center & power mart?
What's a Cube in Rolap?
After the complete generation of a report who will test the report and who will analyze it?
How to use the tool Ontobulider
if source contain 10records how you identify header and footer
What is a staging area? Do we need it? What is the purpose of a staging area?
What are the mapping paramaters and maping variables?
What is IQD file?