What is operational data source (ODS)?
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 multi-dimensional analysis?
What is a hash cluster?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain what are the various transformation available?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Why should we use data ware housing and how can you extract data for analysis with example?
Explain is olap databases are called decision support system true/false?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
How can we load the time dimension?
How did you plan your Data ware house project?
Explain the main differences between star and snowflake schema?
What is operational data source (ODS)?