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 about market structures and price output determination.
Describe briefly the difference between a shared lock and an exclusive lock?
Briefly explain the functional differentiations between COGNOs and BO?
Explain what are the roles performed by the SQL?
Complete the whole assingment. With diagram and completed mysql program
State various types of the input links within the data stage?
Illustrates the third normal form?
What is OLAP? Briefly define it.
Illustrate the term audio data mining.
Explain what is meant by the term universe stage?
18,76,764
1923934 Asked
3,689
Active Tutors
1460918
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!