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.
State the difference between OLTP and OLAP?
Illustrates storing of data in stored procedures increase the access time?
Give a brief introduction of the term critical column?
What are the types of prompt?
What are the Features of Monopoly?
State the steps for “this message could not delete” from the particular tables?
Write down a short note on the term domain constraints?
Write a short note on the difference between embedded and dynamic SQL?
What do you understand by the term Dataset?
Explain the user objects?
18,76,764
1923761 Asked
3,689
Active Tutors
1442443
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!