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
Lookup error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
-
- Participant
- Posts: 63
- Joined: Mon Oct 20, 2008 12:01 am
- Location: Malaysia
How big your lookup file? If not mistake, it will hit this problem when reach around 500MB.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