Hi All
How to resolve the issue.
lookuptable.20100417.stsv13d": No space left on device.
Can we do any tuning in the job.since we cannot increase the resource space for this job alone
This job is having single lookup holding 5 reference.
Thanks for your help
Lookup Space
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Wed Mar 05, 2008 4:09 am
- Location: chennai
- Contact:
Lookup Space
pradeep.v
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is probably a mechanism for loading only the rows you will need into the lookup table.
The technique is known as "bucket table": you generate a list of the keys from source, then join that result to the reference source as part of loading the lookup table.
In the old days, the bucket table was actually created in the database where the reference data originated, and the join done there. In parallel jobs, of course, you can use a Join stage to good effect.
The technique is known as "bucket table": you generate a list of the keys from source, then join that result to the reference source as part of loading the lookup table.
In the old days, the bucket table was actually created in the database where the reference data originated, and the join done there. In parallel jobs, of course, you can use a Join stage to good effect.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.