Chapter 1, Problem 4MBD

Explanation of Solution

One would extract the following types of data mart from the data warehouse to determine the company rankings:

Multidimensional data marts:

• Numeric data can be collected.
• The overall data is managed in a framework.
• The framework is upgraded with the information.

Relational data marts:

• Numeric and textual data can be collected.
• Data marts are created while using indexes.

Networked Data Marts:

• Data is maintained in a standardized format.
• Distributed data marts can be utilized from an individual workstation.
• There exists a standard metadata directory.

The information at times includes crucial information that delays the business just like quarterly balance sheets.

The major issues obtained if the analyzed data is inaccurate are mentioned below:

• Several departments need to be contacted in order to attain the required information.
• If the data that has been fetched is inaccurate, the decisions based on the data will not be correct.
• The efforts put to fetch the data and even the resources go in vain when the information is inaccurate.
• It does not affect a particular department but affects the whole organization as it is well known that several departments need to be contacted in order to attain the required information...