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.
GC_hill 
(BOB member since 2007-08-29)
Do you have this scenario:
A --< B --< C
If yes then you may potentially have a fan trap. Have a look here for an explanation how to solve it:
Marek Chladny 
(BOB member since 2003-11-27)
No I have a situation like this A --< B <–C.
GC_hill (BOB member since 2007-08-29)
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.
Dave Rathbun (BOB member since 2002-06-06)
Yes if it is the star schema. But I do not have a star schema here I have the views coming from transcation database.
GC_hill (BOB member since 2007-08-29)
That doesn’t change my answer. 
Dave Rathbun (BOB member since 2002-06-06)