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.
Tell us what stages are in the job doing what, we have no clue where to begin.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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]