How to avoid repetitive jobs ?

[adelaoc]

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 ?

[Anonymous]

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