Using views in place of tables in teradata connector stage

sachinag · Post by **sachinag** » 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

ray.wurlod · Post by **ray.wurlod** » 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.

chulett · Post by **chulett** » 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.