topic How to propagate a generic schema change to a Oracle Output in Talend Studio

How to propagate a generic schema change to a Oracle Output

Anonymous — Fri, 15 Jun 2018 13:28:17 GMT

Hi !
I have this little problem :
I have a tmap based on a generic schema. Everything works fine. But when I want to make a change on the generic schema (add a column for example) which is used in the job, the modification propagates everywhere except on the Oracle output which automaticaly change from "Repository" to "built-in". My problem is that my generic schema is used in 60 jobs so I must change each job manually.

Is there any way to do it whitout going into each Oracle output.

I'm on Talend Open Studio 5.6 windows version.

Thank you for your help!

Re: How to propagate a generic schema change to a Oracle Output

TRF — Fri, 15 Jun 2018 20:59:56 GMT

That's because tMap output part is not concerned by generic schema. When you add a new column this part doesn't change so the next component doesn't match the generic schema anymore and changes to built-in.
I don't think there is a work around for this. Else I'm interested to know it.

Re: How to propagate a generic schema change to a Oracle Output

Anonymous — Mon, 18 Jun 2018 08:21:03 GMT

Thanks for your answer. I will keep looking for a solution.