Submitted by wolf on Jan 27, 2021

Description

{Add more here about (CIF)}

A data mart is a subject-oriented database object streamlined to facilitate reporting and analytics. They contain the essential information that aligns with the business unit and business domains. A data mart is typically a flattened structure and carries forward the necessary attribution to minimize complex joins. To improve the end-user experience, data marts will include the required joins and multi-source attributions into one object.

In the multi-layered framework of the EDW, data marts are made available to Limited Users in the Presentation Layer. Depending on the performance benefit Data marts are represented as:

  • View objects that query data from Trusted and Raw Layer

  • A table managed in the Trusted Layer that mimics the structure of a data mart, with a one-to-one view built in the Presentation Layer

  • Summarize and aggregate reporting objects. Please note, reporting objects are created by querying the Presentation Layer.

Inmon Model

Helpful Links

{What Objects do we want to include here? }

Bridge Table

1-2-3 Normal Form

Use Case Example

Click this Link to open a document detailing the steps needed to create a BRIDGE table.{TW will update this link}

Click this Link to open a document detailing the steps needed to create a 1st Normal Form table.{TW will update this link}

Click this Link to open a document detailing the steps needed to create a 2nd Normal Form table.{TW will update this link}

Click this Link to open a document detailing the steps needed to create a 3rd Normal Form table.{TW will update this link}