What if the business key is an array?  


Posts: 113
(@patrickcuba)
Estimable Member
Joined: 5 months ago

This is the scenario:

ORG_ID

GROUP_ID

1

100, 105, 600

Org ID is the party and loads to HUB_PARTY

Group ID does not imply a hierarchy but rather a higher level grouping of multiple orgs under a group --- different semantic meaning, different grain, load to HUB_PARTYGROUP. There is no guarantee that the ordering of the group ids will remain the same.

The questions is: how do you treat the GROUP_ID array?  

1) Request that we implement a new interface contract with the 3rd party provider to provide the file like this:

ORG_ID

GROUP_ID

1

100

1

105

1

600

  • This is the best outcome, the array is broken out to individual rows and the data seamlessly flows from source to raw vault.
  • If they are unable to provide it then move onto option 2/3

2) Build in a hard rule before the file is staged.

  • The rule recursively rolls out the content into the rows like option 1 and the data flows into raw vault.
  • It is a maintenance point before RV but one that is unlikely to change

3) Implement it as a soft rule and capture the result into business vault

  • Data remains as was provided but the GROUP_ID cannot be loaded into HUB_PARTYGROUP as is because every entry in the hub is effectively a "new" business entity --- because we cannot guarantee the order of the array.
  • GROUP_ID will have to be loaded as an attribute and any change in the order generates a new row
  • A soft rule will have to query the data in the RV structure and find the latest GROUP_ID to roll out the GROUP_IDs to load into HUB_PARTYGROUP and a business vault link will need to be populated.

In all three options an effectivity satellite is needed to capture the ORG to GROUP movement unless the START and END date is captured in the source.

 

Thanks 

Reply
1 Reply

Please Login or Register