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.
Write a short on the differences of the two principal types of packaged data models.
Give us a non-computer illustration of preemptive and also non-preemptive scheduling?
hatcher also created the accompanying Level 1 data flow diagram for this process. Unfortunately, this DFD has numerous syntax and semantic errors. Identify the errors. Redraw the DFD to more correctly represent the receive supplier shipments process.
Write down the architectural and functional differentiations between Web Intelligence Reports and business objects?
Write down a short note on the difference between partial specialization and total specialization.
Explain the term Job parameters?
Briefly describe the differentiation between Data warehousing and Business Intelligence?
Elucidate how many ways you make ports?
In Sybase does table Partitioning needs user-defined segments?
States the term second normal form?
18,76,764
1953322 Asked
3,689
Active Tutors
1418755
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!