update data base with auto increment key

[AYAHIAOUI1629282039]

hello guys

iwant to update table with auto increment key when i chose insert or update i have error you must have a key

[gjeremy1617088143]

Hi,with auto increment for insert you don't need a primary key, but for update you need the primary key.

also it's better to separate insert and update.

Send me love and kudos

[AYAHIAOUI1629282039]

thank you for your answer but how i can update table with primary key auto increment in data base ???

[gjeremy1617088143]

for update you have to know the key value before the update, without it you can't update with tDBoutput.

Coul you be more precise on your scenario ?

[AYAHIAOUI1629282039]

ido migration data from oracle to postgrsql and in postgresql i have id auto increment for the table and i havn't another key, i want to update with this key auto increment but i didnt found him in talend

[gjeremy1617088143]

Ok let me understand,does oracle table have a specific primary key wich is the same in postgre or can you identify fields wich can make a row unique?

[AYAHIAOUI1629282039]

no i havnt another row unique

[gjeremy1617088143]

Ok let try in an other way.

if both tables were in postgre with the fields they already have could you achieve this and how?

[gjeremy1617088143]

Also maybe you could post the structure of postgre table and oracle Table, it could really helps

[AYAHIAOUI1629282039]

the bdd they havnt same structure i extract data in csv file after that i load them in postgresql. ican update with in postgresql with primary key auto increment but i want to do this with talend.