Stage Dependency

altruist · Post by **altruist** » Sun Apr 26, 2015 2:35 am

Hi

Can I have Dependency on Stages within Datastage Job instead of Sequence ?

For instance, I wan to run update/insert query on two tables, but they have to be performed one after the other with same dataset. Do I have to go for the sequence for this functionality? Is there a way that I can implement this functionality within the same datastage job?

Mike · Post by **Mike** » Sun Apr 26, 2015 7:17 am

Many of the database connectors support multiple input links now. See if that will meet your needs.

What is your target database?

Mike

ray.wurlod · Post by **ray.wurlod** » Sun Apr 26, 2015 4:54 pm

I prefer to use two jobs from a sequence. The first job identifies the inserts and updates, writes the inserts to a Data Set, and performs the updates. The second job performs the inserts.

altruist · Post by **altruist** » Thu Apr 30, 2015 11:21 pm

I have chosen PL/SQL block in the options and executed the insert and then update sql.

I have tested it, and it works fine.

Do you think this could cause any unknown issues later down the road.