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.