Here is very nice blog on best practices around using associations in custom CDS views. Thanks to @Andreas Riehl !

https://blogs.sap.com/2020/03/06/custom-cds-views-using-multiple-data-sources/

Best,

Sandeep