Decode null value

Of course, there's nothing to create an expectation that it doesn't unless like me you come from using DECODE in Oracle and then Informatica's works just the way you expect. As always - it would really help if the function documentation covered all the corner cases! And that is sadly true for practically every function, because the examples usually only cover the most common cases. Absolutely right. So the best thing is to address the documentation people at Informatica and ask them for correction in one or the other direction.

After all much of PowerCenter has been written to mimic Oracle behaviour, and so this would be a good explanation for this behaviour. Either way, I'll try to address this at the doc's department, maybe they can get formal clarification. Error: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.

Please enter a title. You cannot post a blank message. Please enter your message and try again. How can that be? Thanks a million in advance! Kind regards, Nico. It allows you to provide a value, and then evaluate other values against it and show different results. It works similar to an IF statement within other languages. If the provided values are numeric , then Oracle determines the datatype to be returned by checking all of the other data types.

This means that Oracle never evaluates a search if a previous search is equal to an expression. When it comes to the performance of both of these functions, there is minimal difference. See the examples section for more information on how to do this. See the example section below for more information. I find that examples are the best way for me to learn about code, even with the explanation above. This is the same query as above, but with a default value.

As you can see, any record where employees is greater than 20 will show one value, and less than will show another value. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed.