How to handle Null values in informatica?

[lam]

I'd like to know if anyone anyone could help out with this problem I have encountered in informatica.<br>I have created a mapping, which includes an Update Strategy, now the update strategy doesn't seem to work. After loading, there are duplicate rows and not all the values are loaded, however, when I change the NULL values in the mapping to X instead, the Update Strategy appears to work, I get all unique rows. The database used is sybase Adaptive server and Informatica 4.6.1. Any suggestions as to how I can over come this???

 

[hinds]

I have had the same problem with null and SQL overrides: I find if I use an nvl statement, it works. So, for example:

Update tbl_customers
set last_name = :tu.last_name
where
nvl(customer_id, 0) = nvltu.customer_id,0)

Good luck!

 

[Guest_imported]

If you don't want to load NULL in the target , why not &quot;filter&quot; those values before sending to &quot;update strategy&quot; ??

Try this out..

Sanya

 

[1sairam2]

Before Update Strategy Use filter Transformation

 

[khobar]

Hi

You can apply the filter at the source qualifier itself to filter out rows having null rows thereby increasing performance

regards
khobar

 

[blom0344]

Are you aware of the fact that you cannot (in any RDBMS) load a null value into a field that belongs to the primary key of a target!!. Such rows are skipped, and informatica gives good logging on this. Do yourselve a favor by upgrading to 5.1 version. The logging is better handled and performance is sometimes up to a 100% better, because of more efficient internal procedings. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com