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.
Homework E-R Modeling Follow a MOVIE database where data is recorded about the movie industry. The data needs are summarized as follows: _ Each and every movie is identified by title & year
What is meant by the Surrogate key?
Explain the master/detail reports?
How can we remove duplicate rows from the flat file?
Explain the Slice and Dice attribute in the Business Objects?
Why is the multi value or multicolumn problem any other type of the multivalued dependency problem?
Elucidate briefly power center repository?
What does web mining mean
Write about stage administrator and manager?
Describe how operation is carried out within the spiral method?
18,76,764
1958896 Asked
3,689
Active Tutors
1430767
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!