DBA > Job Interview Questions > Data Warehousing Interview Questions and Answers

What are Data Marts?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are Data Marts?

Data Marts are designed to help manager make strategic decisions about their business.
Data Marts are subset of the corporate-wide data that is of value to a specific group of users.

There are two types of Data Marts:

1.Independent data marts sources from data captured form OLTP system, external providers or from data generated locally within a particular department or geographic area.

2.Dependent data mart sources directly form enterprise data warehouses.

(Continued on next question...)

Other Job Interview Questions