The following diagrams visualize the relationships between different tables within the Mercury data warehouse, and between MercuryDW and other datamarts.
There are 2 schemas in SEQPROD
- MERCURYDW - actual DWH refreshed by Mercury ETL
- MERCURYDWRO - provides Read-Only access to data in MERCURYDW.
In the diagrams, PK refers to the PK = Primary Key and
UK refers to Unique Keys within the tables.= Unique Key
| Table of Contents |
|---|
Mercurydw table relationships
...