Re: owb and NVL
- From: Mark Van de Wiel <mark.van.de.wiel@xxxxxxxxx>
- To: tkiernan@xxxxxxxxxxx
- Date: Tue, 29 Nov 2011 12:26:03 -0800
Niall,
I suspect you use lots of lookups which by default use an outer join
with the NVL(). You can change lookup properties to not use an outer
join by default in which case the tool should not generate the NVL().
Mark.
On 11/29/2011 10:58 AM, TJ Kiernan wrote:
> Looking at both my simple and convoluted mappings, I'm not seeing NVL()
> functions except where I wrote them in the GUI, so either this is some
> version-specific muddiness, or there's an ETL developer who gets paid per
> line of code.
>
> For reference, I'm on 11.1 on Windows 2008 x64.
>
> HTH,
> T. J.
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Niall Litchfield
> Sent: Tuesday, November 29, 2011 5:39 AM
> To: ORACLE-L
> Subject: owb and NVL
>
> I'm looking at an OWB generated statement (and so my head is exploding)
> which is full of subqueries like the following.
> SELECT NVL(T1.KEY_VALUE, NULL)...
>
> I sure am puzzled as to why the tool would generate this and not
>
> SELECT T1.KEY_VALUE...
>
> other than to further muddy the waters.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
