Page 1 of 1

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

Posted: Fri Mar 27, 2009 4:19 am
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

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

Posted: Fri Mar 27, 2009 10:25 am
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

Posted: Fri Mar 27, 2009 11:02 am
by samsuf2002
If you are not using RCP, then check the columns from source dataset to target oracle table if any column is missing.