Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain how to get the first 100 rows from the flat file into the target?
What is metadata in context of a datawarehouse and how it is important?
What is core dimension?
Explain what is the difference between view filter and report filter?
Whether dimension table can have numeric value?
What is surrogate key? Where we use it explain with example?
What is data warehouse architecture?
What is the difference between metadata and data dictionary?
What are universe requirements?
What are data validation strategies for data mart validation after loading process?
What is execution plan?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is meant by metadata in context of a data warehouse?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
How to add a number to a macro variable?
