Processing two sequential file

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Processing two sequential file

Post by admin »

Hi,

We are trying to process two sequential file by using Merge stage in DS. Pure Inner Join has been used as join type and compilation was successful. But runtime, it gives warning message as Construct_hash_table failed and job got aborted.

First File size - 23 MB
Second file size - 108 MB

Could it be problem with RAM that are available in ETL server or somethingelse causes this proble.

Appreciated if you could help us in this issue.

Thanks
Saravanan ______________________________________________________________________________________

Visit us at www.singaporeair.com. ______________________________________________________________________________________
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Is this regularly reproducible or intermittent? It looks like a memory
problem, but could be permissions on the server. Have you logged a call
with Ascential support?

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Locked