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.
Objectives create an external DTD that dictates a relational model-like data structure for XML documents. Assignment 1 Description W
Illustrates the term tkprof and how is this used?
Give a brief introduction of the term critical column?
Provide a brief introduction of the term cubes?
What is meant by the Surrogate key?
Illustrates architecture of reporting services?
Explain Data Only Page Locking in Sybase.
Briefly describe the differentiation between star and snowflake schemas?
Write down the employ of incremental aggregation?
Illustrate stored procedures, and how do they are distinct from triggers?
18,76,764
1938492 Asked
3,689
Active Tutors
1430058
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!