Data warehouse can be stated as “a subject-oriented, time-variant, integrated, non-volatile collection of data” in support of management’s decision making procedure.
Illustrate out the above concept and support your answer with suitable instances.
Illustrate out three (3) main benefits which a company will gain by executing a data warehouse.
Illustrate out three (3) problems associated with implementation of data warehouse.
What do you understand by the term Data Mart? Discuss and illustrate out how Data Marts diverge from data warehouses and recognize any two reasons for executing the Data Mart.