|
|
|
Forum Member
 
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
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 !!!
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
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.
|
|
|
|