Fact table load error

seanc217 · Post by **seanc217** » Tue May 09, 2006 2:38 pm

I'm loading a fact table. So I have 9 lookups into the dimensions to get the surrogate key values. The job runs fine then I get:

fact_table_fk_lookups,1: Could not map table file "H:/IBM/DataStage/Resource/DataSets/lookuptable.20060509.uhq5v4d": Not enough space
Operator's runLocally() failed.

I checked the space as it is running and I have more than enough space. The drive I am writing to has 135 GB free. I even tried specifing a second 135 GB drive and it still fails with the same error.

Any ideas?

Thanks

seanc217 · Post by **seanc217** » Tue May 09, 2006 3:08 pm

I think I solved my own problem. I did not have the Oracle lookups set to sparse! So it tries to cram everything into memory.

Thanks