Data Loading in Views using Fastload

Tools
Enthusiast

Data Loading in Views using Fastload

Can I able to Load data in Views using Fastload ???

As if I've tried to load the data in a view using Fastload - it's throwing error!!!
But loading data in a view using Multiload is working fine (with single session / multiple sessions) - it's inserting data in Views.

What's the reason behind this - I mean why can't we load data in Views using Fastload but can using multiload !!
Please explain !!!
1 REPLY
Teradata Employee

Re: Data Loading in Views using Fastload

No explanation needed.

In case you were not aware, for the FastLoad protocol, there is special code that is executed
both on the client and on the database. Many of these restrictions are due to software design
in the FastLoad code on the Teradata database.

When FastLoad was designed many, many years ago, there was a technical reason behind this
decision.

MultiLoad has a different protocol than FastLoad, and there are other technical issues which
may allow for views to be loaded using the MultiLoad protocol that cannot be achieved with
the FastLoad protocol.

In this regard, the utilities should not be compared.
-- SteveF