What is operational data source (ODS)?

Answers were Sorted based on User's Feedback



What is operational data source (ODS)?..

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

What is operational data source (ODS)?..

Answer / samir kumar sahoo

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

Post New Answer

More Data Warehouse General Interview Questions

Explain the definition of normalized and denormalized view and what are the differences between them?

0 Answers  


Explain what is fact less fact table? Where you have used it in your project?

0 Answers  


What is hash partition?

3 Answers   TCS,


Explain what is cost benefit analysis (cba)?

0 Answers  


what are different ways of loading data to data warehouse using oracle?

1 Answers  






What is Conceptual, Logical and Physical model?

1 Answers  


why oracle is the best database for data warehousing?

4 Answers   HCL,


After the complete generation of a report who will test the report and who will analyze it?

0 Answers  


Define Data Warehousing?

0 Answers   Wipro,


Give some difference between oltp and olap.

0 Answers  


ware house management system is used?

0 Answers  


Explain what is the advantages data mining over traditional approaches?

0 Answers  


Categories