I have a question on business keys.
I just completed my training last month and started working on the Data vault implementation. As part of this assignment me and my manager had discussion on the business keys and their location in Data vault model. I argued to keep them on only in HUBS and hash keys in Satellites and links, but my manager want to bring business keys into Links and Satellites to reduce the joins and also he has fear of Hash key corruption.
I argued not to bring them into the satellites and links, but he want me to reach out this forum and check with you all the reason to avoid the business keys into Satellites and Links. Can anybody help with why we can't bring the business keys into Satellite and links ?
Looking for positive response. and thank you all for the help your guys are doing.