Operational data stage and data warehouse
Explain the term operational data stage (ODS) and data warehouse?
Expert
A data ware house is defined as the decision support database for the organisational needs. It is non volatile, subject oriented, integrated, time variant collection of the data.
a) ODS or Operational Data Source refers to an integrated collection of the related information. It consists of the maximum 90 days information.
b) ODS is nothing but operational data store, which is the part of the transactional database. This db keeps the integrated data from different db and enables common operations across the organisation. For example: banking transaction.
c) In simple terms, ODS is the dynamic data.
Explain the performance of SQL Server Reporting Services.
Mini-Case The Hatcher Company is in the process of developing a new inventory management system. One of the event handling processes in that system is Receive Supplier Shipments. The (inexperienced) systems analyst on the project has spent time in the warehouse observing this process and develo
Explain the difference between ARRAY and STACK in Data Structures?
Write a short note on the difference between the disjoint and overlap rule.
Describe the difference between complexType elements and simple elements?
Describe briefly the term ADO.NET?
Specify the tasks of universe designer?
Briefly explain the capabilities and concepts of Business Object?
In Sybase does table Partitioning needs user-defined segments?
What are some of the demerits related with conventional file processing systems?
18,76,764
1928890 Asked
3,689
Active Tutors
1455643
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!