DSXchange

A job is designed with a source oracle stage loading to a target oracle stage through a transformer stage.When the job is executed it aborts with the below error.

Target: Table truncation failed for "SCHEMA.TABLENAME".

Is it a database issue, i.e - Privilege to truncate the table is not given or is it something else that's stopping the job from executing successfully

TRUNCATE is a specific and separate privilege in Oracle.

what should be done to make the job run without the truncation failed error?

natashab wrote:what should be done to make the job run without the truncation failed error?

Check the user rights/privilege of the Oracle user which you are using has the proper right to truncate.

I would think more messages than that would be involved here. The table could be "busy", in use by another process and thus not truncatable.