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
Funnel and lookup problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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
Sorry, have not used the PX funnels yet so I can't help you there.
Vincent McBurney
Data Integration Services
www.intramatix.com