Hi
I have a parallel extender job which does a lookup on a file set using the lookup stage.I have around 100,000 rows in my file set.The lookup works for
some rows which are at the beginning but does not work for other rows which are towards the end of the file.
When i reduced the number of rows in the file set to be 1000.it worked fine.
Did anyone encounter such problems??
Thanks!
Unable to lookup when file is 2megs
Moderators: chulett, rschirm, roy
Re: Unable to lookup when file is 2megs
Hi
I did some more testing..,
There is a funnel stage in the job that builds the file set.
Once i removed the funnel and used a user defined sql to do the join it worked.I was using a continuous funnel.
Pls feel free to add any comments.
regards
I did some more testing..,
There is a funnel stage in the job that builds the file set.
Once i removed the funnel and used a user defined sql to do the join it worked.I was using a continuous funnel.
Pls feel free to add any comments.
regards
deep wrote:Hi
I have a parallel extender job which does a lookup on a file set using the lookup stage.I have around 100,000 rows in my file set.The lookup works for
some rows which are at the beginning but does not work for other rows which are towards the end of the file.
When i reduced the number of rows in the file set to be 1000.it worked fine.
Did anyone encounter such problems??
Thanks!