A informatica workflow is failing with the space error. We have increased cache space but still showing the same error.
ERROR: Could not allocate space in file [%s].
Experts please answer.
Thanks for reading,
Note: log file is enclosed
if possible please try these options..
Try to change the master table as the one with smaller number of records..As only usually the records in the master table only cached..u can save some space.
Remove the unwanted columns in the joiner trabsformation..so data and index cache wont be created for unwanted columns.
try to increase the total memory percentage to an good extent in the session property,instead of incresing the cache space seperately.
try to pass the sorted records in the joiner transformation