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.
Explain different domain which is there in BO?
Name four applications which are employing for triggers in DBMS?
Briefly explain the capabilities and concepts of Business Object?
What is the main dissimilarity between horizontal and vertical partitioning?
How can we handled are recursive relationships in a database design? Describe briefly?
What is Enterprise Resource Planning (or ERP), and what type of a database is employed in an ERP application?
Explain the way to audit the SQL sent to the server.
What do you understand by the term Relationships in DBMS?
Define the term filter?
How can I partition any table in Sybase? Explain.
18,76,764
1941390 Asked
3,689
Active Tutors
1430616
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!