Skip to Content
0

Run the the jobs in sequential

Feb 21 at 04:02 PM

41

avatar image

Hi ,

I have multiple sets of tables ( Each set is from different data store configuration and tables are identical)

I have to load the each set of data sequentially. So I am going to keep in the single job.

But each set is from different data store configuration so system configuration also different for each set.

In this case , how can I execute the different sets sequentially by giving different system configurations.

Thanks & Regards,

Venkata Ramana Paidi.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Feb 26 at 11:58 AM
0

Hi Ramana,

Are all the table sets from different underlying server? If all are from same server but different DB then you can use SQL transform and write a select statement on different DB and perform a union operation. In this case no need to create system config and run the job multiple times.

Thanks,
Sandhya

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Sandhya,

Thanks for your response.

Actually table sets from different server with Oracle DB. Thats why we are choosing data store configurations.

Thanks & Regards,

Ramana.

0
Rajan Burad Feb 27 at 06:06 AM
0

Hi Ramana,

Instead of choosing different data store configuration you can create separate datastore connections with different configurations. Post this extract the tables from different datastores created and do the mapping. Since you said that you need to load data sequentially, assuming target table is same, use Transaction order property of DS..

set include in transaction to 'Yes' and define the order.

Hope it helps!

Thanks.


1.png (1.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
Ravi kiran Pagidi Feb 27 at 11:01 AM
0

System configurations wont work If you want to have all the flows in a single job. Insetad create different jobs for each source type and then use system config while scheduling (in data serveices) or while generating .bat files select system config and generate bat files (if 3rd party scheduler).

Or create different datastores instead of single datastore with multiple configs and have all flows in a single job.

Share
10 |10000 characters needed characters left characters exceeded