Skip to Content

Run the the jobs in sequential

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed 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.

  • Feb 27 at 06:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 27 at 11:01 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded