This content has been marked as final. Show 4 replies
Answered by Steve Muench
Here is the email response I got from Steve.
There is no way in ADF to mark a view link as a left-outer join type.
For your specific requirement, all need to be done is add a custom property on VL:
Property name: BI_JOINTYPE with either of these values.
LEFTOUTER | RIGHTOUTER | FULLOUTER | INNER
Edited by: Eshwar Mekala on Feb 8, 2010 1:58 PM
Edited by: Eshwar Mekala on Feb 8, 2010 2:03 PM
Edited by: Eshwar Mekala on Feb 8, 2010 2:06 PM
We had a view link containing outer join syntax but it broke when we attempted to change the linked view to use ANSI joins because you can't combine the Oracle(+) syntax with ANSI "OUTER JOIN" join syntax. I'm guessing we can't use an outer join view link with a view configured to use ANSI joins. Is that the case?