Handling Nulls for decimal fields in transformer stage
Posted: Wed Sep 13, 2017 3:25 pm
Hi,
My requirement is If there are NULLs present in source (Oracle table) for decimal fields then I need to convert them into Blanks in target (Flat file ).
Transformer derivation ,I wrote
After I perform the "Left outer Join" ,these decimal fields returning 0 (Zero) instead NULL .
I read the forum posts ,Its the expected behavior for decimal fields .But How Can I perform null handling for decimal fields ?
Please suggest me how to handle this in transformer stage ?
Thanks.
My requirement is If there are NULLs present in source (Oracle table) for decimal fields then I need to convert them into Blanks in target (Flat file ).
Code: Select all
oracle (source) > Leftouter Join >XFM > DataSet >cdc >Flatfile
Code: Select all
If IsNull(lnk_col1) Then '' Else lnk_col1
I read the forum posts ,Its the expected behavior for decimal fields .But How Can I perform null handling for decimal fields ?
Please suggest me how to handle this in transformer stage ?
Thanks.