You are not logged in.
I use tInputFileDelimited an tOutputOracle, my table Oracle is alimented by insert with the dynamic schema.
The "insert" mode is ok
and now i would like use the "insert or update" mode too, course i need the key but I do not know how to recover the key ( I do not know the table will be updated , (dynamic schema))
If someone can help me ...
Merci beaucoup ;-)
Last edited by surfary (2012-05-15 23:05:56)
Welcome to Talend Community!
Please check the structure of this table at DB side. Maybe you can find one column to be primary key.
Now modify the schema of Talend job as the following image.
thank you pedro,
But your method works when you know the key, in my case, I do not even know the table that will be transferred (dynamic schema).
The key must also be dynamic in order to use the mode Upsert
If you have any ideas?
Sorry. It seems there isn't any workaround. For updating, you have to add a key column in Talend job.
Or the component don't know how to generate update sql statement.