I have one master job which contains hashfile ,transformer stage and output from transformer.In the transformer i am calling another job which contains a stored proc in the source and it takes the input from hasfile(from main job) and loads one by one.so thsi taking 24 hrs to load 5000 rows.Please advice me.stored proc is taking the way they wrote is calling proc with in the proc as i am not the original devoloper.Can we do anything performance increase from datastage side?
thanks in advance.
Master job calling another child job taking 24 hrs for 5000
Moderators: chulett, rschirm, roy
Confusing. Are you saying that each record in the master job triggers another job that runs a proc for just that row?
If so, no wonder it is horribly slow. What does the proc do that is so important you can't do it directly in the 'master' job?
![Shocked :shock:](./images/smilies/icon_eek.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers