Hi, in this case you'll have to add the Employee.DepartmentId column and use department id as an affinity key in all caches.
On Mon, Feb 3, 2025 at 9:13 AM <satyajit.man...@barclays.com> wrote: > Hi Pavel, > > > > I have lets say three below caches and want to join using Affinity > key for these three caches so that data is collocated . So how > affinity key needs to be built for Employee Cache and Organization > Cache so that Employee Cache, Oganization Cache and DepartmentCache are > collocated.? > > > > I have seen examples of two cache using Affinity key. Need to > understand for joining more than two caches using affinity keys. > Please share the example. > > > > > > Employee Cache > > Int id, > > Int name, > > Int OrganizationId > > > > > > Organization Cache > > Int id, > > Int name, > > Int departmentId, > > > > Department Cache > > Int id, > > Int name. > > > > > > Regards > > Satyajit > > Restricted - External > > Barclays Execution Services Limited registered in England. Registered No. > 1767980. Registered office: 1 Churchill Place, London, E14 5HP > > Barclays Execution Services Limited provides support and administrative > services across Barclays group. Barclays Execution Services Limited is an > appointed representative of Barclays Bank UK plc and Barclays Bank plc. > Barclays Bank UK plc and Barclays Bank plc are authorised by the Prudential > Regulation Authority and regulated by the Financial Conduct Authority and > the Prudential Regulation Authority. > > This email and any attachments are confidential and intended solely for > the addressee and may also be privileged or exempt from disclosure under > applicable law. If you are not the addressee, or have received this email > in error, please notify the sender and immediately delete it and any > attachments from your system. Do not copy, use, disclose or otherwise act > on any part of this email or its attachments. > > Internet communications are not guaranteed to be secure or virus-free. The > Barclays group does not accept responsibility for any loss arising from > unauthorised access to, or interference with, any internet communications > by any third party, or from the transmission of any viruses. Replies to > this email may be monitored by the Barclays group for operational or > business reasons. > > Any opinion or other information in this email or its attachments that > does not relate to the business of the Barclays group is personal to the > sender and is not given or endorsed by the Barclays group. > > Unless specifically indicated, this e-mail is not an offer to buy or sell > or a solicitation to buy or sell any securities, investment products or > other financial product or service, an official confirmation of any > transaction, or an official statement of Barclays. >
