I want to confirm if we can we override physical join in BMM layer? For e.g we have two table A and B connected by employee_id in physical layer. Can we override or create a new join condition in BMM layer to join these two tables by SSN instead? Some of the areas are greyed out in BMM layer.
You have to use Foreign key join in BMM layer. Looks like you are using complex join in BMM layer.
Appreciate if you mark as correct else let me know.
Edited by: Srini VEERAVALLI on Jan 18, 2013 10:47 AM
Thanks so much Srini for your kind reply!!
It shows the list of relationship.But ,the areas are grayed out in 11g to change the join relationship.
However, the column that we use for new physical join condition is calculated logical column.
See you have to delete the existing join to create Logical foreign key join in BMM layer using Manage->Joins
You can go with joins with logical columns too.. works well.
If need send me an email with screenshots
@Antonio: Yeah.. that option need to check. I remember I've answered same question long back to some one.. the option was checked in my rpd and ignored to mention. Thanks for update back.
Edited by: Srini VEERAVALLI on Jan 18, 2013 11:21 AM