Modelling Multi-Operating Company Data

urn:js:virtue:aspire:standard:29.1

TL;DR

Method to allow cross company identifiers to be unique.

Definition

Currently ADW contains very little Non JS data and hence the idea is not change to the JS identifiers in the Dimensions/Facts. And only make changes to the non JS data

For Argos/Habitat we can add the Store/Item numbers with a number
Ex: ARGOS identifiers added with 100000 and Habitat identifiers added with 200000
ARGOS Store 123 becomes 100123<
Habitat Store 456 becomes 200456
Have an additional column to capture the original identifier
Only one column will be used to join the Dimensions to Facts

Appendix

Migrated From Confluence

link Original Author : Gunda, Suneel