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.

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.