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 Primary Key and UK refers to Unique Keys within the tables.