DS Temp Dir Space issue

rprasanna28 · Post by **rprasanna28** » Wed Jun 13, 2007 11:46 pm

I have designed a lookup job. When I try to execute that job Iam getting the following error message

"LKP_AL_YES_COEP,0: Could not map table file "/dsetlsoft/datastage/Ascential/DataStage/Datasets/lookuptable.20070613.ujo03nc (size 1733722784 bytes)": Not enough space

Error finalizing / saving table /tmp/dynLUT6390006fc4e533"

We tried executing the job after increasing the Temp Directory memory but still we are facing the same error.

Could any one suggest me in solving this.

Regards
Prasanna Lakshmi R

balajisr · Post by **balajisr** » Thu Jun 14, 2007 12:05 am

What is the size of your reference data?

Use join instead of lookup if your reference data is huge.

rprasanna28 · Post by **rprasanna28** » Thu Jun 14, 2007 12:26 am

I HAVE AROUND 33 LAKH RECORDS IN MY REFERENCE TABLE

Hemant_Kulkarni · Post by **Hemant_Kulkarni** » Thu Jun 14, 2007 3:01 am

If your input data is relatively less, use sparse lookup instead

rameshrr3 · Post by **rameshrr3** » Thu Jun 14, 2007 7:06 am

For those not in the 'know'

33 LAKH = 3.3 Million

DSguru2B · Post by **DSguru2B** » Thu Jun 14, 2007 7:50 am

If your source is equally huge, go for a join stage to join the records. If your source is small, go for a sparse lookup.