Hello , In a Use case We have data coming from 20+ sources which will be loaded into the RDV as Separate source driven satellites, so 20 Source feeds will load 20 different Satellites .
Next , we are divided on the best approach for the Business data Vault - should the Source based satellites (some of which need more enrichment and transformation than others) be merged into one harmonized Satellite in Business Data Vault or does it make more sense to maintain the source based split in the Business Data Vault Satellite as well ?What factors should be considered to make this selection ?
Other details : Data will be loaded daily with some 100 million records / day from one source on a Apache Spark Based cloud platform.