How to get data from 2 hubs with proper history context from satellite


I need help for consumption from the following DV model:




Case scenario:

What is the best practices query to get history of customer with proper context(different addresses Address1 and Addres2) for each application(applicationid=1 with address1 and applicationid=2 with address2) ?

I suppose any attributes go to the satellite they depend, even if addresses look a customer thing, in your scenario they (customer address) really should go to link satellite.
I suppose you could also store 1 address to be historized in customer satellite if you had some is_main_address flag on customer file.

A second option, i suppose would be to use a multi active satellite on customer adding application_id as extra column.