I have a scenario where there is source 1 which contains its set of business keys lets say 100 records. Then I have another source - source 2 (master source) which has more records for same business entity lets say 200 records. For the common 100 records between the 2 sources I am able to map the business key in both systems but for non common records there are null value for BK in master source.
How to model in this scenario:
- Zero key scenario
- Add BK from 2 sources in same hub and create a SAL for common BK
- Create them as 2 different hubs and create a link between them
Appreciate any guidance.