Clear all

Multi-Active Satellite - Multiple Dependent Child Keys?

Posts: 0
Topic starter
Joined: 52 years ago

I understand that we can use a "Dependent Child Key" when we have multiple active satellite records for a given business key.

Are we restricted to have only one attribute as "Dependent Child Key"? OR can we have multiple attributes?

Ex: Lets say source system has defined country code and phone number are as 2 different attributes and a person can have multiple phone numbers. We have a HUB for person and Multi-Active Satellite to hold the phone numbers.

So the Satellite key can be Person Hash Key + Country Code + Phone Number + Load Date ?


5 Replies