All Forums Teradata Applications
06 Mar 2016
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?

cmedved 24 posts Joined 02/14
10 Mar 2016

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.

You must sign in to leave a comment.