tMap - not giving unmatched records

[Anonymous]

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?

[manodwhb]

Can you show your tmap settings?

[manodwhb]

Is source is main flow?

[Anonymous]

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

[manodwhb · Accepted solution]

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.