If we have three tables and the middle table gets a one to many join on one key from another table ie this table being the many side and its get a one to many join on an other key from an other table again this table being on the many side, what are the common issues.
That’s a fairly standard result in a star schema. You should be fine unless you have measures from A, B, and C all at the same time. Normally I would expect dimension objects from A and C and measures from B.