0
Lokið

How to draw a one-to-many relationship between a DIM and a FACT table so that the PK of the DIM will flow into the FACT

Claire Frankel 5 ár síðan updated by Adam Mościcki 5 ár síðan 1

How to draw a one-to-many relationship between a DIM and a FACT table so that the PK of the DIM will flow into the FACT ?

claire.frankel@warbyparker.com

Answer

Answer
Lokið

Hello Claire,

Please:

1. Choose the 'add reference' tool.

2. Start dragging from a DIM table.

3. Drop mouse on a FACT table.

Hope this helps,

Adam

Answer
Lokið

Hello Claire,

Please:

1. Choose the 'add reference' tool.

2. Start dragging from a DIM table.

3. Drop mouse on a FACT table.

Hope this helps,

Adam