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 !!!
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.