What is operational data source (ODS)?

Question Posted / guest

2 Answers
10547 Views
I also Faced
E-Mail Answers

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

in general which algorithms for used?

0 Answers

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

0 Answers

Explain what is the difference between datawarehouse and bi?

0 Answers

What is surrogate key?