Lookup error

lak4u · Post by **lak4u** » Sat Jan 03, 2009 9:56 pm

When I lookup with the table(sql server) I am getting following error... anybody can help?

Could not map table file "D:/DataStageFilesystem/Datasets/lookuptable.20090103.q2tvyqd (size 7995709648 bytes)": Invalid argument

vmcburney · Post by **vmcburney** » Sun Jan 04, 2009 7:12 pm

That's a big lookup file it's trying to create! Have you tried it with a join stage instead? You can do an order by on the SQL Server select and tell the job the data is already sorted to prevent DataStage from sorting it again for a join.

ratikmishra1 · Post by **ratikmishra1** » Fri Mar 13, 2009 3:02 pm

Did you get this resolved. I am getting the same error. My look up size is really small. So, it should fit in. Just wondering if you managed to get this working.

Note. I am getting this error only 8.1 not in 7.5.x. Same job runs fine.

Thanks
Rati

siauchun84 · Post by **siauchun84** » Tue Mar 17, 2009 1:53 am

ratikmishra1 wrote:Did you get this resolved. I am getting the same error. My look up size is really small. So, it should fit in. Just wondering if you managed to get this working.

Note. I am getting this error only 8.1 not in 7.5.x. Same job runs fine.

Thanks
Rati

How big your lookup file? If not mistake, it will hit this problem when reach around 500MB.