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 several of the products of Sybase?
Write down the architectural and functional differentiations between Web Intelligence Reports and business objects?
How to produce an Auto Incremental Number within a SSIS Package?
Provide a brief introduction of the term cubes?
Demonstrate some of the techniques which can be employed to tune operational performance?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
What is meant by the Drill Through?
Write down the differentiation between Power Center and Power Mart?
Illustrate why informational and operational systems are separate?
Under what conditions should indexes are employed?
18,76,764
1931648 Asked
3,689
Active Tutors
1418398
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!