[resolved] tMap left outer join to insert/update and delete records

[Anonymous]

Hi,
I have one problem about delete record from table. In my job, I take tAccessInput do left outer join via tMap with tPostgreSQLInput (I need to update some Access column with postgres table column). I want to update or insert row that exist in tAccessInput to Postgres table and to delete record that doesn't exist in Postgres table.
Can you tell me how to do it ? I read some posts that we can create two different outputs in tMap to tPostgreSQLOutput which one performs insert/update and the other output performs delete. Bud I don't know how to do this with left outer join.
Best regards,
Sophanna

[Anonymous]

what is "catch lookup inner join reject means"?
Check this tutorial https://help.talend.com/search/all?query=tMap&content-lang=en for the description of "Catch lookup inner join reject"
Vaibhav

[Anonymous]

Hi,
Sorry for asking repeated question. Could you tell me beside map these two table with primary key, do I need to give another criteria to get the rejected row that doesn't match this join.
Sophanna

[Anonymous]

Hi This is Prashant.I Have 10 Records Excel File.I am Converting it into Access File.And the Fields Names are First Name,Surname,Title, Gender,Year etc.Now I Want to Update Particular Row in Access File.For Example if the First Name is Smith i Want to Make it as John.Please Help me Regarding with this.

[_AnonymousUser]

Hi Team,
I am trying to do CDC using file system.
I have 2 input files(.csv) one for current day and one for previous day.
I wanted to compare these 2 files and get the Inserted,updated and Remains unchanged records into 3 different flows.
I tried it using tmap component but i m not able to acheive it.
can anyone help me with this?
Thanks,
Srinivas