topic Re: [resolved] Do not join on nulls in tMap in Data Quality

[resolved] Do not join on nulls in tMap

Anonymous — Wed, 15 May 2013 21:28:24 GMT

Is there a setting in the tMap component so that when performing a join, it does not consider two null values to be a match? Like in SQL, if you say:
WHERE colA = colB
with both colA and colB being null, it will not return any records as it does not consider null = null to be true.
I can code around this in the join, of course, but that is a big pain.
Thanks!

Re: [resolved] Do not join on nulls in tMap

Anonymous — Thu, 16 May 2013 03:29:24 GMT

Hi,
You can set a filter in tMap in output source.
See my screenshot
Best regards
Sabrina

Re: [resolved] Do not join on nulls in tMap

Anonymous — Thu, 16 May 2013 16:58:35 GMT

This doesn't quite solve the problem because it does null checking after the join has been performed. So the join still happens between the two records, but then the result is filtered out. This is not what I want since I am performing a left join - I still want the data from the source table to come across, just not the data from the joined-to table.

Re: [resolved] Do not join on nulls in tMap

Anonymous — Fri, 17 May 2013 04:27:38 GMT

Hi,
You can set a filter in the input source of ""LookUp".
See my screenshot
Best regards
Sabrina

Re: [resolved] Do not join on nulls in tMap

Anonymous — Wed, 22 May 2013 18:10:07 GMT

Thanks, Sabrina!

Re: [resolved] Do not join on nulls in tMap

Anonymous — Thu, 23 May 2013 03:39:38 GMT

Hi,
You are welcome. Don't hesitate to post your issue on forum.
Best regards
Sabrina