DSXchange

Do you pass any special characters through the fields?

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?

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