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.
How can we handled are recursive relationships in a database design? Describe briefly?
Briefly describe the foreign key columns in dimension table and fact table?
Write a short note on an ERD?
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
Explain how is the HASH file used and where we can use it?
Illustrate the main merits of employing stored procedures?
How would the developer describe all variables using referential data types?
Write about the components of the Ascential Data Stage?
Describe some of the chrematistics of good data definitions.
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
18,76,764
1925099 Asked
3,689
Active Tutors
1441854
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!