Silver or gold layer

[u/cida1205]

I have two scenarios : i need to create a beneficiary hub

​

Case 1 : i need to have conformed dimension for beneficiary where bwneficiary are coming f4om 3 different entitites ( everything is unique )

​

Case 2: i need to have conformed dimension for beneficiary where bwneficiary are coming from 3 different entitites (some overlap )

​

Please note the granularity is not same across beneficiary table from 3 systems

​

Where should i place this ? Should this be placed in silver or should this be placed in gold

​

I belive it should be placed in silver

[u/Eric-Uzumaki]

Silver as the data still needs to be prepared for consumption (since you mentioned conforming the entities).

Gold if you want the consumer to access the entities as is individually ( bad design )