kumar_s wrote:Are you renaming from "input0Int8nLDD_X1" to "X1"?
Is the source field Not Null? ...
Hi Kumar, I am not renaming the field input0Int8n_X1 (it was generated internally within datastage)
ArndW wrote:Is X1 nullable in your source link?
Hi, X1 is nullable in source (secondary link)
creatingfusion wrote:
Probably you have to apply the function NullToEmpty function only on Null values.... so check if the value is null then apply NullToEmpty
So yours derrivation for the input should be .....
If IsNull(%inputcol%) Then NullToEmpty(%inputcol%) Else ''
This field is hardcoded in middle [metadata is nullable through all upstream jobs]. Looks like whenever nullable the field is getting empty string assigned to i. I have checked for the metadata definitions right from the origin, but is nullable everywhere and there is no provision to change the default values of metadata.