Fastload to VIEW

Tools

Fastload to VIEW

I am using fastload scripts to populate directly to a view(myview ).

But i am getting an error :

Begin Loading myview errorfiles mytable_e1,mytable_e2;
RDBMS error 3853: 'myview' is not a table.

How to resolve this? Is it possible to populate directly to view?
1 REPLY
Teradata Employee

Re: Fastload to VIEW

Hello,

As you said, FastLoad loads in tables not the views, you need to load the underlying table(s) for updating view.

I suppose "RDBMS error 3853: 'myview' is not a table." is pretty self-explainatory.

Regards,

Adeel