'NULL' string not replacing in Transformer.
Posted: Thu Oct 16, 2008 7:57 am
Hi Dsxians,
I am experiencing a strange problem in transformer stage for some columns and for some datastage
jobs alone ,when i am trying to replace a 'NULL' string from source with setnull() function for a target
decimal column 28,12.Derivation is below.
If Trim(ACTION_SRC_3_PAMPositionAfterExchangeJoin.BOOK_VALUE)='NULL' Then setnull() Else StringToDecimal(ACTION_SRC_3_PAMPositionAfterExchangeJoin.BOOK_VALUE)
Even if i am not mapping this column with 'NULL' value to target I am getting this below warning.
TRN_POS_VALIDATIONS,0: A numeric string was expected, got "NULL"; using Decimal, the default value. [transform/tfmop_functions.C:448]
Could you please let me know any suggessions or thoughts.Thanks for your time.
Thanks
snt_ds
I am experiencing a strange problem in transformer stage for some columns and for some datastage
jobs alone ,when i am trying to replace a 'NULL' string from source with setnull() function for a target
decimal column 28,12.Derivation is below.
If Trim(ACTION_SRC_3_PAMPositionAfterExchangeJoin.BOOK_VALUE)='NULL' Then setnull() Else StringToDecimal(ACTION_SRC_3_PAMPositionAfterExchangeJoin.BOOK_VALUE)
Even if i am not mapping this column with 'NULL' value to target I am getting this below warning.
TRN_POS_VALIDATIONS,0: A numeric string was expected, got "NULL"; using Decimal, the default value. [transform/tfmop_functions.C:448]
Could you please let me know any suggessions or thoughts.Thanks for your time.
Thanks
snt_ds