What is a Data Mart? – Types and Benefits

Data Marts

Datamart can be defined as the subset of a data warehouse of an organization which is limited to a specific business unit or group of users. It is a subject-oriented database and is also known as High-Performance Query Structures (HPQS).

Types of Data Marts

Data marts are of two types – Dependent and Independent.

• Dependent Data Mart – This data mart depends on the enterprise data warehouse and works in a top-down manner.
• Independent Data Mart – This data mart does not depend on the enterprise data warehouse and works in a bottom-up manner.

Watch this Informatica video

Benefits of Data Marts

• Allows the data to be accessed in lesser time
• Cost-efficient alternative to the bulky data warehouse
• Easy to use as designed according to the needs of a specific user group
• Fastens business processes.