I have two fact tables:
a) FACT_PURCHASE_ORDERS fields: -PO_Number -Pick Ticket Number -PO_Line_Number (po can have many line numbers) -PO_ITEM (PO_number concatenated with PO_Line_Number with dash IE. "10-1")
Example:
| PO_number | PO_Line_Number | PO_Item |
|---|---|---|
| 10 | 1 | 10-1 |
| 10 | 2 | 10-2 |
| 10 | 3 | 10-3 |