Updating records in a table from another table usindg talend

[Anonymous]

hello all
i am having two tables tab1 and tab2 which are replicate of each other.there are no keys in it .
i update column in tab1 through database and run the job then in tab2 it is not getting updated.
job flow is
toracleinput1>>>tmap>>>toracleoutput1
if i enable traces debug option i am able to see updated row on the output link getting fetched but in database it is not updated.
the newvalue field is having 48 as updated value ,in talend it is geeting fetched but when i check in db it is the same old value...ignore the error sign on toracleoutput..it is some other reason
thanks....

[Anonymous]

Hi,
The table 1 is input source table and table 2 is target?
Is there any row is rejected by DB? How did you set your oracle output component? Is there 0 rows/s? Could you please paste your job screenshot into post so that we can get your situation more precisely.
Best regards
Sabrina

[Anonymous]

this is the job yes input table is src and output is target .i just want to udate it....
i used use field option but which should be update key as there are no keys

[Anonymous]

this is the job yes input table is src and output is target .i just want to udate it....
i used use field option but which should be update key as there are no keys

[Anonymous]

Hi,
You can set a key for your target table so that it can be updated without reduplicated data.
Best regards
Sabrina

[Anonymous]

Hello
the problem is there is no key in both source and target tables.
thanks....

[Anonymous]

Hi,
Set a key by editing schema of toracleoutput manually.
Best regards
Sabrina

[Anonymous]

thanks for help
but there has to be some unique column in db for setting it as key which is not there all values are duplicate anyways update is not possible in this case .as in talend there must be atleast one key for using update option.
thanks....

[Anonymous]

Hi,
Could you please elaborate your case with an example with input(all values are duplicate ) and expected output values?
There is also option for "Insert or Update on duplicate key and unique index"
Best regards
Sabrina

[Anonymous]

Hi,
I am facing the same issue. Even after declaring the column of the target table as key, it is not being updated. Please refer my screenshot.

P.S. - Since I need to update the table, I have chosen 'Default' value for Action on table field and 'Update' for Action on data in my tPostgresqlOutput component.