As they arrive
The sources Four source tables and the source system seed: every column real, each relationship the sources never declare drawn dashed with its measured match rate.
The course's source data, as it lands Four source tables from three sources: Sunbelt Senior's client list and policy sales data, Northfield Life's policy data, and Pinecrest Mutual's policy data for the learner's labs. No source declares how its rows relate to another table's; the dashed relationships hold only where the values match, and the agent is an entity no source sends. Sunbelt Senior's client list SUNBELT.CLIENT CRM_ROW_ID CLIENT_NUMBER FIRST_NAME LAST_NAME STATE LOADED_AT Sunbelt Senior's policy sales SUNBELT.POLICY_SALE SALE_ROW_ID POLICY_NUMBER CLIENT_NUMBER CARRIER_CODE ROLE SOLD_ON AGENT_NAME AGENT_NPN PLAN_NAME LOADED_AT Agent, sent by no source known only by the producer number Northfield Life's policy data NORTHFIELD.POLICY POLICY_NUMBER INSURED_ID INSURED_NAME BIRTH_DATE ADDRESS FACE_AMOUNT STATUS EFFECTIVE_DATE WRITING_AGENT_NPN LOADED_AT Pinecrest Mutual's policy data PINECREST.POLICY, for your labs POLICY_NUMBER PLAN_NAME FACE_AMOUNT STATUS EFFECTIVE_DATE WRITING_AGENT_NPN LOADED_AT client number carrier and policy number producer number Sunbelt Senior (SSI) Northfield Life (NFL) Pinecrest Mutual Tap to enlarge As integrated
The vault built from them Four hubs, three links and four satellites; the carrier the labs add drawn dashed.
The vault the course builds Four hubs keep the business keys, three links record which keys belong together, and satellites keep each source's details with their history. Pinecrest Mutual's policy details, drawn dashed, are what the learner's labs add. Sale details (satellite) Sunbelt Senior Policy details (satellite) Northfield Life Client on policy (link) with the role Insured on policy (link) Client (hub) client number Policy (hub) carrier's policy number Insured (hub) insured number Client details (satellite) Sunbelt Senior Agent on policy (link) Insured details (satellite) Northfield Life Agent (hub) producer number Policy details (satellite) Pinecrest Mutual Sunbelt Senior Northfield Life Your labs Hubs and links Tap to enlarge Why it is shaped this way The design explains every hub, link and satellite, and the choices behind them.
Read the design