Re: owb and NVL

From: Mark Van de Wiel <>
Date: Tue, 29 Nov 2011 12:26:03 -0800
Message-ID: <>


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().


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: [] On Behalf Of Niall Litchfield
> Sent: Tuesday, November 29, 2011 5:39 AM
> 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.
> I sure am puzzled as to why the tool would generate this and not
> other than to further muddy the waters.

Received on Tue Nov 29 2011 - 14:26:03 CST

Original text of this message