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.
Elucidate how many kinds of dimensions are accessible in the Informatica?
Illustrates the term normalization?
Explain the object qualification?
Explain the ways to controlling Cursor Behavior.
Explain the various types of the designer tools?
Illustrate the term data mart. What do you mean by it?
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
Write down the working procedure of Online Databases.
Explain the usage of the repository connectivity?
Why do we utilize a Multidimensional Array within data structure?
18,76,764
1954039 Asked
3,689
Active Tutors
1437140
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!