How to create dependency between two independent pipelines

[samuelmj]

I have two pipelines in the job.

I would like to know how to create a dependency, such that one pipelines runs first and then the other one.

Both the pipelines are independent, taking data from different source table and loading into different tables.

I could create two jobs and create a dependency in the sequencer, but I would like to know if this can be done in the same job.

[qt_ky]

Technically, I suppose you could take pipeline1 and copy part of it into a Lookup stage as the reference link. My opinion is that the proper way is what you mentioned already using 2 jobs plus a sequence job. It would depend on your reason or if you're just curious.

[samuelmj]

Thank you for the response...

I was working with Informatica PowerCenter and recently started working with DataStage.

In Informatica there is an option called, target load order. which can be set, which determines which pipleline in the mapping runs firts.

I was wondering if there is any such option in datastage.

Thank u.

[chulett]

No, there is no equivalent to Informatica's "Target Load Plan".

[samuelmj]

Thanks Craig appreciate it.