Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Source is Main flow,destination table act as lookup table. row12 coming as source , row9 coming as lookup table. NotExist->insert into destination table