Hi,
I need help for consumption from the following DV model:
-hubs
H_CUSTOMER
H_APPLICATION
-satellite
S_CUSTOMER_ADDRESS
-link
L_APPLICATION_CUSTOMER
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.
