empty string to null

[anvitha]

Null value in oracle gets converted to empty string(which is treated as null in oracle though) in postgres when used with source_lookup function.

without source_lookup function, null is migrated as null.

Since there isn't testing calls for source_lookup, would want suggestions on how do I check the result of it which might probably be to check the target table. If so, how do I ensure null is converted as null even with source_lookup?

[john_wang]

Hello @anvitha ,

I tried to validate the NULL value by adding nullif() function however it does not help while use source_lookup (it does work while without source_lookup), my expression looks like:

nullif(source_lookup('NO_CACHING','SCHEMANAME','TBLNAME','COLNAME','PKCOL=:1',$PKCOL),NULL)

 I'd like to suggest you open a  support case and check further if you need the feature. 

Regards,

John.