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 what are the possible data marts in retail sales?
Code the tables statement for a single-level (most common) frequency?
in general which algorithms for used?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are data validation strategies for data mart validation after loading process?
What are the steps involved in designing a fact table?
what is user variable in affinium campaign? and some real time examples.
Explain is olap databases are called decision support system true/false?
What is aggregate fact table?
Explain what are the advantages data mining over traditional approaches?
How can you clear the cache?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is a data profile?
Explain what are data marts?
How to pivot data using informatica when you have variable amount of pivot rows?
