Abnormal End error while running a DS load job into Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
So what you are saying is that there were 3 columns in the source data file that did not map into the target OCI stage.
How did you "remove" them? These columns need to be defined in the Sequential stage else it gives warning messages. You would have to suppress row truncation messages. What exactly did you do?
How did you "remove" them? These columns need to be defined in the Sequential stage else it gives warning messages. You would have to suppress row truncation messages. What exactly did you do?
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
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,
Thanks for your patience and replies.
I looked at my data fields closely and found that I have almost 5 variables with a varchar(255) size. Out of this 5, only 3 were getting populated and remianing 2 were set to @null in the DS. What I did, its a waste process by the DS when I have null values, rather I can have oracle take care of that at table level.
So I removed those 2 fields from my jobs and now the job runs fine. I kept the triggers,condition based uniue constraint as it is.
Now, can any one explain me if this looks fine.
RC
Thanks for your patience and replies.
I looked at my data fields closely and found that I have almost 5 variables with a varchar(255) size. Out of this 5, only 3 were getting populated and remianing 2 were set to @null in the DS. What I did, its a waste process by the DS when I have null values, rather I can have oracle take care of that at table level.
So I removed those 2 fields from my jobs and now the job runs fine. I kept the triggers,condition based uniue constraint as it is.
Now, can any one explain me if this looks fine.
RC