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.
Define the term merge stage?
MiniSQL Parser Relax; you don't have to write the parser! On the contrary, a complete parser and type checker for the MiniSQL language is provided with the skeleton code. This small subset of SQL includes the
Describe the difference between a regular sub query and a correlated sub query?
Explain and compare OBE and SQL?
Name four applications which are employing for triggers in DBMS?
Illustrates a stored procedure?
Why is the multi value or multicolumn problem any other type of the multivalued dependency problem?
partial specialization and total specialization rules in enhanced erd.......
What are two types of implementation as a centrally located logical architecture? Answer: There two types of implementation are as follows: firstly gives a single ve
Specify various tools in the Business Objects 5.1?
18,76,764
1933432 Asked
3,689
Active Tutors
1456103
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!