DSXchange

Posted: **Tue Jan 11, 2011 11:21 pm**

Hi,

I am trying to load data using teradata connector stage using a one to one view instead of table. I am using "Bulk" mode and Load as the operator. But the job is aborting with RDBMS error code 3853 which says that the table name used is a view.

Can anyone give inputs on this issue

Thanks and Regards
Sachin

Posted: **Wed Jan 12, 2011 4:07 am**

At a guess, Teradata does not permit the bulk loader to be used with a view. You will get more information from your Teradata errors manual.

Posted: **Wed Jan 12, 2011 7:54 am**

... and/or your Teradata DBA.

Does any database allow a bulk load to a view? Other than RedBrick.

DSXchange

Using views in place of tables in teradata connector stage

Using views in place of tables in teradata connector stage