Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Why joiner transformation does not allow the aggregator transformation and expression transformation to join

2 Answers  


which automation tool is used in data warehouse testing?

1 Answers  


Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

0 Answers  


What is freehand sql?

0 Answers  


What is the extension of file to save template?

0 Answers  






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

1 Answers  


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

0 Answers  


Explain what are the different types of data warehousing?

0 Answers  


How to drill through from a powerplay cube to reportnet?

0 Answers  


What are Aggregate tables?

0 Answers  


what is the difference between aggregate table and fact table ? how do you load these two tables ?

12 Answers   Target,


What does level of granularity of a fact table signify?

0 Answers  


Categories