How to make "insert table" wihtout duplicate input data?
Hi, I load data from table 1 to table 2. And every time I run Talend job, it will insert duplicate data to table 2. How can I make this to throw exception or SQL constraint? Thanks, Vincent
All apologies, you're right, if I check the key column as "Key in update" and "Updatable" it works...
But there is an unecessary update that is done.
Thanks for your help Vaiko and Volker.
But I think that an action on data "Insert if not exists" can be interesting to manage this case and other case when you don't want to update your data.
Hello laurie, please add a feature request in the BugTracker. Better than "Insert if not exist" would be "Ignore duplicate key error on insert" I think. Your version sound like a (unnecessary) select will be executed before the insert. Bye Volker
This hint below is very useful.
"Shong gave me the hint to look at the advanced tab. Set the option "Use field option" ... "
Took me a couple of hours to work that out.
Hi, could you please provide the "insert if not exists" functionality also for the tOracleOutput component? (I have also a unique constratint which give an ORA-... error when someone tries to insert a duplicate...) That would help a lot as Oracle is the industry standard... Thanks, dstefane