Skip to Content
0
Former Member
Jul 30, 2016 at 03:51 PM

Lookup Expression in output column (instead of new function call)

97 Views

1) why do we use lookup_ext expression in instead of new function call? is it like look up over ride? following is used in our project so checking.

lookup_ext([Lookup_TableName,'PRE_LOAD_CACHE','MAX'], [LookupTable_Outputcolumn],[ifthenelse((inputsourceTable_matchingcolumnName IS NULL ), -2, -1)],[LookupTable_MatchingColumn,'=',inputsourceTable_columnName,LOGICAL_DELETE_IND,'=','N']) SET ("run_as_separate_process"='no', "output_cols_info"='<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/>

</output_cols_info>' )



2) Another Look up NULL value comparison general Question,


if input source column has null values and look up table comparison column does not have null values then what does look up output returns? NULL or nothing?


for some reason my look up output port returning null values and that null values are trying to insert into NOT NULL constraint column and getting error. My source input comparison column has Null values and lookup comparison does not have NULL values but output of look up port returning nulls. how to avoid null output values.