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.
In OLE DB, what is the difference between an implementation and an interface?
Explain the repository domains?
Briefly describe the differentiation between star and snowflake schemas?
Explain the isEmpty() member method called.
Explain the function of metadata for the three-layer architecture?
Core Competency: Helps the managers to think towards developing the core competencies with the help of cloud computing. Huge benefits can be reaped out of the cloud computing.
What are some of the impediments to good decision making? Given the availability of copious information, why do good managers still make bad decision?
What do you understand by the term snapshot replication in DBMS?
Write down a short note on the difference between an ERD and EER.
How many modes are there in Business objects and Designer?
18,76,764
1945253 Asked
3,689
Active Tutors
1449744
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!