Page 1 of 1
Teradata Connector vs Teradata Multiloader
Posted: Tue Oct 12, 2010 10:51 pm
by kiranredz
I would like to know the Difference Between Teradata Connector stage vs Teradata Multiloader stage.
Also, Can you please suggest which stage would be a best option to use to load huge amount of data - say 5 million rows per run.
Thanks in advance!
Re: Teradata Connector vs Teradata Multiloader
Posted: Wed Oct 13, 2010 6:16 am
by kiranredz
kiranredz wrote:I would like to know the Difference Between Teradata Connector stage vs Teradata Multiloader stage.
Also, Can you please suggest which stage would be a best option to use to load huge amount of data - say 5 million rows per run.
Thanks in advance!
Sorry! I was referring to the Teradata enterprise stage
Posted: Fri Dec 03, 2010 1:01 pm
by daignault
Always use the Teradata MLoad stage. Bulk loading will be much faster.
Ray D
Posted: Tue Dec 14, 2010 1:23 pm
by pauliex
The Teradata Connector is significantly quicker than the Teradata Enterprise or MultiLoad stages. It uses Teradata's Parallel Transporter. The Teradata Connector should be used for all modes of interfacing with Teradata.