Hi Ajay-Pandey ,

Here is my scenario: In our current situation, we need to load data in multiple stages. Each stage includes a set of insert statements. Instead of running these statements one after another, we can run them in parallel to save time.

Stage1: (below insert statements A,B,C needs to run parallel)
Insert into table A
Insert into table B
Insert into table C

Stage2: (below insert statements D,E needs to run parallel)
Insert into table d based on A,B
Insert into table e based on B,C

Stage 3 (below insert statements F,G needs to run parallel)
Insert into table f based on d
Insert into table g based on e

Stage 4
insert into table h based on above tables

Regards,Janga