topic How to avoid repetitive jobs ? in Talend Studio

How to avoid repetitive jobs ?

adelaoc — Sat, 16 Nov 2024 07:43:56 GMT

Hello,

I have developed around 150 jobs for a big project, most of them are reading information from Oracle and then loading the data into HDFS (Staging Area), now I do not want to continue doing the same thing over and over again.

I am looking for a way to have1 job that does everything since the tasks is repetitive, and then using some sort of metadata to achieve the goal of loading the data to early stages.

Advices ?

Re: How to avoid repetitive jobs ?

Anonymous — Mon, 03 Sep 2018 03:01:45 GMT

hi adelaoc,

If there are no major transformation involved then there are multiple ways to design this job.

you could tried sending SQL dynamically via context variables. An example is given here : https://help.talend.com/reader/UKa8DT70H4IhAZ~xKO7X_Q/s9uKfIs7nHzoSWf3ecdPYA
Use DI jobs with dynamic metadata for oracle and then call bigdata jobs

Thanks,

RekhaSree