What happens when a Foreign Key Join is defined in BMM Layer of OBIEE?

Hi friends,

I am searching for more details on this particular post. I will update you soon on this particular post.Please keep visiting.

If a physical join (foreign key join) is used in the BMM layer, then BI Server will always select this physical join to create the SQL even when it is not the most efficient one.