Page 1 of 1

How many lookup job we can create idaelly inside one job

Posted: Mon Sep 08, 2008 3:45 am
by kaushal
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.

Posted: Mon Sep 08, 2008 6:50 am
by ray.wurlod
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.