Netezza Enterprise Stage outputs N instead of NULL
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
Netezza Enterprise Stage outputs N instead of NULL
Hello Experts !
I have a very straight-forward mapping, with the following structure:
Netezza Source ---> Transformer ---> Netezza Target
I am facing a very strange situation here. A particular row has NULL value in one of the columns in the back end table. However, when i click on the "View Data" on the source and take a look at this row in the dataset, i see that this column value has been converted to N instead of NULL.
Please note that this problem occurs for 1 row only. Not for all the rows. So it looks like it is not a Null conversion error.
Hoping to hear back from you guys soon.
I have a very straight-forward mapping, with the following structure:
Netezza Source ---> Transformer ---> Netezza Target
I am facing a very strange situation here. A particular row has NULL value in one of the columns in the back end table. However, when i click on the "View Data" on the source and take a look at this row in the dataset, i see that this column value has been converted to N instead of NULL.
Please note that this problem occurs for 1 row only. Not for all the rows. So it looks like it is not a Null conversion error.
Hoping to hear back from you guys soon.
Arpit Chopra
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
I have another piece of information that might be helpful. This column under question used to be of datatype CLOB in Oracle (from where this table was created in Netezza).
However, its datatype was changed to Varchar(4000) to be compatible in DS and Netezza. Can this be a reason ?
But if the table itself shows NULL then why do I see N in the source stage in DS ?
However, its datatype was changed to Varchar(4000) to be compatible in DS and Netezza. Can this be a reason ?
But if the table itself shows NULL then why do I see N in the source stage in DS ?
Arpit Chopra
It was changed in the database or just in the job?
Honestly, I have no idea why you are seeing what you are and suspect it will take 'boots on the ground', eyeballs there to figure it out. What do you get if you select DUMP(YourColumn) from YourTable in Oracle? Have you involved your official support provider yet?
Honestly, I have no idea why you are seeing what you are and suspect it will take 'boots on the ground', eyeballs there to figure it out. What do you get if you select DUMP(YourColumn) from YourTable in Oracle? Have you involved your official support provider yet?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
...another thought is...."is it really null" ....and....if so......"Does it matter?"
Null is null...who cares how it is interpretted by a "display" tool.... does it satisfy true for isnull()? ..just like all the other rows that you believe are null?
If it does, then it is still NULL, regardless of what you might see. And if not....should it be NULL ?
...at least, that is the corruption I would be concerned with, as opposed to "N" ......(they might be one and the same problem --- just want to sure it is being considered from a true null-behavior point of view).
Ernie
Null is null...who cares how it is interpretted by a "display" tool.... does it satisfy true for isnull()? ..just like all the other rows that you believe are null?
If it does, then it is still NULL, regardless of what you might see. And if not....should it be NULL ?
...at least, that is the corruption I would be concerned with, as opposed to "N" ......(they might be one and the same problem --- just want to sure it is being considered from a true null-behavior point of view).
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
at the back end... yes.eostic wrote:...another thought is...."is it really null" ....and....if so......"Does it matter?"
Null is null...who cares how it is interpretted by a "display" tool.... does it satisfy true for isnull()? . ...
but when i do a straight dump into a target, the same row magically has N instead of NULL.
Arpit Chopra