It exists a faster way to implement your Business Link Data Flow Set: you can use the Derived DWH Object HubCreditCard_RDV_Hub_Result_VI_SQL:
No need of a join between Hub and Satellite.
Derived DWH Objects permits to create new DWH Objects based on existing Target Objects. They are new model objects without generated code: they point to an existing Target Object.
In this case we can directly use the Result View containing data from the Hub HUB_CreditCard and the Satellite SAT_CreditCard to access the hash key for the relationships to the Hubs and the CardType information for the filter.
All the the details can be found in our community site.
Hint: If you already are a biGENIUS user and have no access to our community site, please ask the biGENIUS support.
Read more about biGENIUS
Read the next biGENIUS Hack