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.
Specify the System variables?
What is a derived (artificial) primary key? When must this be used?
Why do not you utilize GNU SCONS or autoconf for building?
Describe briefly How can we configure mapping in the informatica?
States the term Volatile temporary tables.
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Name some of the applications that use Multilinked Structures?
Explain about the stored-procedures and its advantages.
Specify what data sources are available?
Explain what is Designer?
18,76,764
1958731 Asked
3,689
Active Tutors
1459909
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!