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.
Briefly describe the employ of aggregate tables and lookup tables?
State the different types of the folders?
Describe briefly the four JDBC driver types which Sun defines?
What are the techniques in which an Oracle database can be created?
What is Data Manipulation Language?
Illustrates the introduction about economics?
What do you understand by the termed dependency graph in DBMS?
Describe briefly the term Session and Batches?
Illustrates the recursive stored procedures?
Specify the use of data stage designer?
18,76,764
1951383 Asked
3,689
Active Tutors
1426869
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!