Hanging a Multi-active SAT from a LINK?

Data Vault 2.0
,
1

Hello all,

Is it okay to hand a Multi-active SAT from a LINK?

Here is our use case:

We have Orders. Each Order has several Order Lines. Each Line has a separate release schedule. For any given release schedule there are 1 or more status associated with it.

We are thinking of have a LINK that houses the Order Lines and Order Line Schedules as Dependent Keys. And then hang hang the MA SAT from this Link with the Statuses as as MA components.

Here is the model:

See: SATM_ORDER_LINE_ITEM_SCHEDULE_NODE and LINK_ORDER_LINE_ITEM_SCHEDULE_NODE

ORDER_RELEASE
ORDER_RELEASE992×1015 116 KB

Is this a valid approach?

Thanks,
Saqib

2

Why would it be a bad idea?

3

Hi @patrickcuba . Just wanted to run it by the DV community to make sure we are not overlooking something obvious…

4

Looks good to me. As always with these sort of questions I suggest building it and trying it out. It won’t take long and you will learn a lot more about your data as a result.

1 Like
5

Thanks @neil.strange ! :slight_smile: Yea we are trying it out using #dbtvault :slight_smile: