What is operational data source (ODS)?
- 2 Answers
- 9544 Views
- I also Faced
- E-Mail Answers
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 |
Explain what are the possible data marts in retail sales?
How can we run the graph? What is the procedure for that?
Explain what is the difference between olap and datawarehosue?
ware house management system is used?
what is difference between drill & scope of analysis?
Where the applications and where
I know of using applysimple, but there are other ways too?
Why is dimensional normalization not required?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain what are the advantages of query studio compared to report studio?
Explain what are the various reporting tools in the market?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Teradata 
