tSalesforce output - upsert key column (QUESTION)

[Ryszard_Rogalski]

Dear All,

I have a question about tSalesforce output - upsert key column.

I want to know how exactly does it work.

I did some research and I found out that it tries to match the UpsertKeyColumns between the orgs, but when the first org UpsertKeyColumn is empty - the value is taken from the Id field by default (so it compares org1.Id and org2.UpsertKeyColumn field).

Am I thinking right?

Thank you in advance.

Edit:

I had mapping inside the tMap, that fills in the UpsertColumn so it turns out that UpsertMatching is being done on temporary created records inside tMap, not on records from previous org.

[manodwhb]

@Ryszard Rogalski​ ,it will do update based on the key column,which you can change .

check the below link.

https://help.talend.com/reader/~JrHURluxR5dMtQmHpZHGg/L7v6Y9bUV7~yjGvzEfBY7A

Thanks,

Manohar