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.
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
What is meant by the Drill Through?
Explain the drill mode?
Cloud Computing – A computing capability that provides an abstraction between the computing resource and its underlying technical architecture (e.g., servers, storage, networks), allowing convenient, on-demand network access to a shared pool of
Illustrate the main merits of employing stored procedures?
What accurately is SQL Server 2005 Service Broker?
Explain All Pages Locking in Sybase.
Define the explaining plan and how is this used?
Explain what is meant by the term universe stage?
Give brief introduction of the term broad cast agent?
18,76,764
1957170 Asked
3,689
Active Tutors
1439405
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!