Snaps execution in pipeline

[Siva_Venna]

I ran into a typical scenario where snaps are not executing in the order they are supposed,below is the screenshot shows the order snaps are being executed. need help me to resolve this.Thanks full_incremntl_sql_2020_09_28.slp (13.7 KB)

[lazo_ilijoski]

Hi @Siva_Venna,

The snaps Oracle-Insert and Oracle-Select1 are not connected (connector is white, instead of blue), and that’s why the order of the execution of the snaps is not as expectd.

Regards,
Lazo

[Siva_Venna]

Hi @lazo.ilijoski
in my pipeline the snap left unconnected intentionally, prior to this pipeline I have designed another pipeline as you see below, in this also I have an unconnected snap but it is working as expected for me!

[lazo_ilijoski]

Hi @Siva_Venna,

Probably order of execution of the unconnected snaps/streams depends on the order of creation of the starting snaps in the pipeline. Since, the order of the executions cannot be guaranteed and if you want to guarantee the order of executions, then I suggest all snaps to be connected by using copy/router or any other appropriate snap.

Regards,
Lazo

[Siva_Venna · Accepted solution]

@lazo.ilijoski
Probably order of execution of the unconnected snaps/streams depends on the order of creation of the starting snaps in the pipeline - I think execution is not based on order of creation if so my pipeline would have executed as expected. Anyways it’s good to have snaps connected to avoid this kind of issues. will consider your suggestion.Thank you