Thank you Venkat Batchu. That worked really well.
I have another question for you if you don't mind.
Can we control the no. of rows to be inserted from the local table for the above scenario?
What I mean is, in first iteration, insert first row of global datatable and 1 to 3 rows
from local datatable. In second iteration, second row of global and 4th row of local datatable and in
the third iteration, insert third row of global datatable and 5,6 rows of local datatable and so on. Please let me know.
Thank you for your time and help.
I have another question for you if you don't mind.
Can we control the no. of rows to be inserted from the local table for the above scenario?
What I mean is, in first iteration, insert first row of global datatable and 1 to 3 rows
from local datatable. In second iteration, second row of global and 4th row of local datatable and in
the third iteration, insert third row of global datatable and 5,6 rows of local datatable and so on. Please let me know.
Thank you for your time and help.