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 ?