DSXchange

Hi All,
I have to run a job on ascential datastage with around an estimate of 600000 rows of data. The job terminates with warning" Abnormal termination of the job at the stage XXX"
However, when i run this job with giving the "limit " <say limit of 350000> it runs with no issues. Else directly running this job terminates it with warning.

Can anyone help me in troubleshooting this map.


Thanks in Advance
Laxmi

Tell us what stages are in the job doing what, we have no clue where to begin.

Hi,
This is a smple job with two transformation stages. the first transformer stage eliminates all the empty spaces using "StringSpaces" . The second transformer has three hash file lookups performed. The schema looks something like this:


Source---->Transf Stage---------> Transf stage----------------> Target
.....................[Null handling]-----[ three lookups]

Looking ahead for response from the group
laxmi

And "StringSpaces" is what, a custom routine or transform? Can you post the code for that as well?

Which stage is the "XXX" stage that aborts?