Truncate & Load in Oracle Stage job is aborting due to F

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gnan_gun
Participant
Posts: 30
Joined: Thu Aug 02, 2007 5:31 am
Location: Mumbai, India

Truncate & Load in Oracle Stage job is aborting due to F

Post by gnan_gun »

Hi,

My Job design is DataSet to Transformer, Transformer to Oracle Stage. In Oracle Stage I am doing Truncate then Load.
The job has aborted due to following error.

"Describe failed because of a missing column for SOURCE"

Even I dont have any column with SOURCE name.

Can any one help on this.

Thanks
Gnan
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Re: Truncate & Load in Oracle Stage job is aborting due

Post by priyadarshikunal »

gnan_gun wrote:Hi,

My Job design is DataSet to Transformer, Transformer to Oracle Stage. In Oracle Stage I am doing Truncate then Load.
The job has aborted due to following error.

"Describe failed because of a missing column for SOURCE"

Even I dont have any column with SOURCE name.

Can any one help on this.

Thanks
Gnan

Check RCP settings
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

If you are not using RCP, then check the columns from source dataset to target oracle table if any column is missing.
hi sam here
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”