topic Re: tMap - not giving unmatched records in Talend Studio

tMap - not giving unmatched records

Anonymous — Fri, 10 Apr 2020 17:18:36 GMT

Scenario:

First load - destination table inserted let say 2 records

Source:

id, value

1, val1

2, val2

Destination:

id, value

1, val1

2, val2

Next Load: logic

check id before insert into destination table

Source ->

tMap (inner join mapped id-id ; and made tru for inner join reject rows) -> if exist (no action) if not exist (insert)

Destination ->

Source:

id,value

1, val1

2, val2

3, val3

now what is happening: the record 3 is not coming from unmatched flow.

what i am doing wrong?

Re: tMap - not giving unmatched records

manodwhb — Fri, 10 Apr 2020 17:21:31 GMT

Can you show your tmap settings?

Re: tMap - not giving unmatched records

manodwhb — Fri, 10 Apr 2020 17:25:33 GMT

Is source is main flow?

Re: tMap - not giving unmatched records

Anonymous — Fri, 10 Apr 2020 18:42:05 GMT

Source is Main flow,destination table act as lookup table. row12 coming as source , row9 coming as lookup table. NotExist->insert into destination table

Re: tMap - not giving unmatched records

manodwhb — Sat, 11 Apr 2020 01:09:04 GMT

Have you joined properly, you need join in left side only from main to look up. Why you have written filter expression for not exist output sections? Looks you have not joined properly.