Talend community forum / dynamic schema / insert or update (upsert)

surfary · 2012-05-15 22:47:40

Hi,
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)

pedro · 2012-05-16 04:24:55

Hi

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.

Regards,
Pedro

Uploaded Images

surfary · 2012-05-16 10:52:47

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?

pedro · 2012-05-16 11:22:34

Hi

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.

Regards,
Pedro

surfary · 2012-05-16 12:32:47

It is not possible to retrieve a dynamic key?
Apparently the tOracleOutput does not manage two dynamic fields ...
You confirm?

pedro · 2012-05-17 03:50:55

Hi

I confirm... The key must be assigned during job design.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-05-15 22:47:40

dynamic schema / insert or update (upsert)

#2 2012-05-16 04:24:55

Re: dynamic schema / insert or update (upsert)

#3 2012-05-16 10:52:47

Re: dynamic schema / insert or update (upsert)

#4 2012-05-16 11:22:34

Re: dynamic schema / insert or update (upsert)

#5 2012-05-16 12:32:47

Re: dynamic schema / insert or update (upsert)

#6 2012-05-17 03:50:55

Re: dynamic schema / insert or update (upsert)

Board footer