How many lookup job we can create idaelly inside one job

kaushal · Post by **kaushal** » Mon Sep 08, 2008 3:45 am

Hi I have created on job,inside which i have lot of lookup jobs,the problem what i am facing that since two lookup job using same table in input,so the number of row count/sec steadly decreasing and it goes below a limt which is not acceptable,so acn u give a suggestion that idaelly how many lookup job we can create inside one job and how i come out from this row count/sec problem.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 08, 2008 6:50 am

No, because there are too many variables, such as row size and number of rows in each reference set and what you are using to provide rows to the reference links.