mac4rfree85 wrote:Since i am working in Server job, i was not able to use NulltoEmpty() function.
Of course you can use it... but it will do exactly what you've already done. If it is "not working" then you either don't have nulls, are confusing an empty string with a null or have an Oracle target where your empty string gets automatically converted to a null.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Whenever you extract that field from the database use any null handling function like COALESCE function because it may happen that database null does not match with data stage null
soumya5891 wrote:Whenever you extract that field from the database use any null handling function like COALESCE function because it may happen that database null does not match with data stage null
Do you have any proof of this? Over the last 13 years I've found DataStage null handling to be quite reliable, no matter what database was involved.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
i am pulling data from SAP table and loading it to Oracle stage.. In SAP table, when i check, these columns are NULL and i am not doing any transformation.. Its a direct pull but when i check the the Oracle stage, instead of empty string am getting only Null Value. ..
But that's correct! If you're pulling NULL from SAP and inserting untransformed data into Oracle, then you should expect to see NULL in Oracle.
You can't trim NULL (at least not till version 8.5). To detect NULL, therefore, you need to apply the IsNull() function to the original input column, as MT suggested. To reiterate, if you want to transform the NULLs into zero-length strings:
... and even then Oracle will turn the empty string back into a NULL when you load it, from what I recall and noted above. Is there some problem with a null in your source being a null in your target as well?
-craig
"You can never have too many knives" -- Logan Nine Fingers