Apparently,
NULL != a number
Doesn't evaluate to anything in Informatica.
So, if you have two variables "existing_x" and "new_x" and you're trying to route off whether they are different or not, and you do something like this:
"existing_x != new_x" in your router condition, it doesn't satisfy the condition if one of the values is NULL, and the other one is not null.
What a pile of garbage.
I had to force the NULL value to be zero before it would work.
I'm also ready to kill someone. Whoever wrote the code to handle that would be a good candidate.
Subscribe to:
Post Comments (Atom)
Hi Curtis,
ReplyDeleteI strongly suggest you speak to your Informatica adminstrator or read up on documentation.
If you compare something to null, it will return null unless you have specified it in the server setting TreatNullInComparisonOperatorsAs
This is in your Adminstrator Guide.
I have been using PowerCenter for close to a decade now and have seen the evolution. There is a lot of good code in there (and a few bugs which they do fix).
In my opinion there really is nothing better out there in comparison for data integration.
Regards,
Sanjay
That's the way it's always worked in SQL, so you'll be wanting to kill someone in ANSI. It's non-intuitive and a pain to remember, and I've made the mistake plenty of times myself.
ReplyDeleteNerfherder