DSXchange

Posted: **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

Posted: **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.

Posted: **Thu Jun 14, 2007 12:26 am**

I HAVE AROUND 33 LAKH RECORDS IN MY REFERENCE TABLE

Posted: **Thu Jun 14, 2007 3:01 am**

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

Posted: **Thu Jun 14, 2007 7:06 am**

For those not in the 'know'

33 LAKH = 3.3 Million

Posted: **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.

DSXchange

DS Temp Dir Space issue

DS Temp Dir Space issue