Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
anvitha
Contributor
Contributor

empty string to null

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?

 

Labels (1)
1 Reply
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!