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
kiranredz
Premium Member
Posts: 21 Joined: Wed Aug 06, 2008 8:34 am
Location: United States
Post
by kiranredz » Tue Oct 12, 2010 10:51 pm
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
Posts: 21 Joined: Wed Aug 06, 2008 8:34 am
Location: United States
Post
by kiranredz » Wed Oct 13, 2010 6:16 am
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
Posts: 165 Joined: Tue Mar 30, 2004 2:44 pm
Contact:
Post
by daignault » Fri Dec 03, 2010 1:01 pm
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 » Tue Dec 14, 2010 1:23 pm
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