Standard Schemas And Their Definitions
The framework comes with standard schemas. If these schemas are not created, certain scripts may fail. You will create these schemas in the environment set up section.
Last updated
The framework comes with standard schemas. If these schemas are not created, certain scripts may fail. You will create these schemas in the environment set up section.
Last updated
Schema
Database
Description
Definition
dw
EDW
Data Warehouse
All base data warehouse tables that are physically implemented belong in the dw schema.
This is an opinionated approach. The whole point of an EDW is that it is all supposed to be one integrated thing. I have seen data warehouses implemented in a manner that uses schemas to group logically related objects.
Mediocre.
There is no law that says you can't do that, but it violates the spirit of a data warehouse.
cm
ODS
Common Model
All common model tables go in the WAIT FOR IT.....the common model schema.
rpt
ODS
Report
Any table that records de-normalized reporting information in support of load management goes in the rpt schema.
vol
ODS
Volumetrics
Tables that are involved in statistical control processes used to manage the EDW load go in the vol schema.
The difference between vol and rpt is that vol tables are normalized in support of small applications that perform statistical analysis. rpt tables are just flat tables to dump de-normalized data into.
mdm
ODS
Master Data Management
Any tables that are involved in the processing of mdm data but are not staging tables go in the mdm schema.
ms
ODS
Multi-System
Stage tables that combine data from more than one system go in the ms schema.