Multiple sessions in Fastload

Teradata Applications
Enthusiast

Multiple sessions in Fastload

i tried making two sessions in fasload 1st got passed with inserion and 2nd didnt showed any such behaviour.
so why cant we have multiple sessions in fastload to load multiple tables?
Tags (1)
1 REPLY
Enthusiast

Re: Multiple sessions in Fastload

Fastload can only load one table per job. Increasing the sessions will generally increase the throughput of the load - the sessions can connect to multiple nodes to push data in parallel. All of the sessions are used to load the same table. The benefit of more sessions depends on the size of your system. The Multiload tool can load to multiple tables.

However, in general, you should use the newer TPT utilities (TPT Load, TPT Update). TPT Update is capable of loading to multiple tables.