Page 1 of 1
Lookup error
Posted: Sat Jan 03, 2009 9:56 pm
by lak4u
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
Posted: Sun Jan 04, 2009 7:12 pm
by vmcburney
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.
Posted: Fri Mar 13, 2009 3:02 pm
by ratikmishra1
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
Posted: Tue Mar 17, 2009 1:53 am
by siauchun84
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.