topic Re: [resolved] Insert & Update with tMap? in Talend Studio

[resolved] Insert & Update with tMap?

Anonymous — Sat, 16 Nov 2024 13:32:17 GMT

Hi,
I am wondering how should I create the mappings & lookup if I want to insert data into the database if the primary key value doesn't exists and update the existing data in the database if any data is changed.
My input is data from MySQL database and Output is an Oracle database. I have a simple mapping such as:
tMySqlInput --> Main --> tMap --> Main --> tOracleOutput (with Action on Data = Insert)
Based on the above mapping, how can I create mappings & lookup if there is new data from MySQL, data will be inserted into Oracle and if there is a data changed from MySQL, an update should be executed in Oracle? Should I create a tOracleInput as a lookup?
Please any help is really appreciated!!
Thanks!

Re: [resolved] Insert & Update with tMap?

Anonymous — Tue, 23 Feb 2010 06:15:05 GMT

Hello

how should I create the mappings & lookup if I want to insert data into the database if the primary key value doesn't exists and update the existing data in the database if any data is changed.

Only select 'insert or update' item on action on data list, check 'key' box of primary key column on schema of tOracleOutput, don't need do any lookup on tMap.
Best regards
shong

Re: [resolved] Insert & Update with tMap?

Anonymous — Tue, 23 Feb 2010 20:18:17 GMT

Hi Shong,
Thanks! It works great; however, can you please explain the difference between "insert or update" & "update or insert" items in action on data list? Is the difference on the sequence which action is triggered first?
Thanks again

Re: [resolved] Insert & Update with tMap?

Anonymous — Wed, 24 Feb 2010 02:46:32 GMT

Hello

Is the difference on the sequence which action is triggered first?

We can say that it get the same result between "insert or update" & "update or insert", the only difference is which action is triggered first as you said.
Best regards

shong

Re: [resolved] Insert & Update with tMap?

Anonymous — Wed, 24 Feb 2010 08:15:12 GMT

If you expect more data to be inserted than data to be updated, use Insert or Update and viceversa.

Re: [resolved] Insert & Update with tMap?

Anonymous — Mon, 29 Mar 2010 13:58:42 GMT

it doesn't work for me !!!!

Re: [resolved] Insert & Update with tMap?

Anonymous — Tue, 30 Mar 2010 03:55:16 GMT

Hello
To imanouch87, please create a new topic and describe your problem.
Best regards
Shong

Re: [resolved] Insert & Update with tMap?

Anonymous — Fri, 24 May 2013 07:01:22 GMT

Can u please provide any screen shots for this.....? which can help us too good.