Monday, 3 March 2014

DATA MART

A data mart is a subset of the data warehouse, which concentrates on a specific business unit. A data mart, may or may not derived from a data warehouse and is aimed at meeting an immediate requirement.

Data marts may or may not dependent on other data marts in an organization. If the data marts have conformed dimensions and facts, then these data marts will be related to each other.

Benefits of data mart:
·                     Frequently needed data can be accessed very easily.
·                     Performance improvement.
·                     Data marts can be created easily.

·                     Lower cost in implementing data mart than a data warehouse.

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...