Interested to Buy Any Domain ? << Click Here >> for more details...
What is operational data source (ODS)?
- 2 Answers
- 10584 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 |
What is up date strategy and what are th options for update strategy?
Explain where do we use semi and non additive facts?
What is the very basic difference between data warehouse and operational databases?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are situations where snowflake schema is better than star schema when the opposite is true?
What are the approaches used by optimizer during execution plan?
How to get the first 100 rows from the flat file into the target?
how to calculate sum(sal) with out using aggregator satge
Which is the optimized method of extracting the data.
How to design file watch jobs?
How to handle multi value dimensions?
What is the difference between narmal load and bulk load?
Teradata 
