Teradata Connector vs Teradata Multiloader

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kiranredz
Premium Member
Premium Member
Posts: 21
Joined: Wed Aug 06, 2008 8:34 am
Location: United States

Teradata Connector vs Teradata Multiloader

Post 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!
Kiran
kiranredz
Premium Member
Premium Member
Posts: 21
Joined: Wed Aug 06, 2008 8:34 am
Location: United States

Re: Teradata Connector vs Teradata Multiloader

Post 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
Kiran
daignault
Premium Member
Premium Member
Posts: 165
Joined: Tue Mar 30, 2004 2:44 pm
Contact:

Post by daignault »

Always use the Teradata MLoad stage. Bulk loading will be much faster.

Ray D
pauliex
Participant
Posts: 1
Joined: Tue Jan 08, 2008 8:02 am

Post 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.
Paul Stanley
IBM
Post Reply