i am doing look up between two databases one is DB2 and other is SQL.
the column name GEO_1 is coming from DB2 database and doing look up with sourcesystem_value column with SQL database to get MD_id from SQL Database.
The requirement is that if look up failed then MD_id is hardcoded -911.In other words the req is given below also
1.keep null if what the source provides
2.MD_id;hardcode -911 if not found
i tried with the following way
Code: Select all
if isnotnull(GEO_1) then -911 else MD_id.
if GEO_1 is null then keep null as source given but if GEO_1 have value and not found in look up then -911 harcoded.
Please help me on this.