Funnel and lookup problem

bigpoppa · Post by **bigpoppa** » Mon Aug 18, 2003 3:12 pm

I know this is a lot to ask but:

1. Could you post the score file/config file?
2. Could you post how much data is in each lookup?

Thanks,
BP

vmcburney · Post by **vmcburney** » Mon Aug 18, 2003 7:28 pm

You need to identify which part of the job is creating your performance bottleneck. Create five copies of the job. Remove a different lookup from each of the five jobs. Run each job for about five minutes and record the processing rate. This should give you a rough idea of what overhead each lookup incurs. Post the details of the lookup that appears to be the slowest.

Sorry, have not used the PX funnels yet so I can't help you there.

Vincent McBurney
Data Integration Services
www.intramatix.com