Hi,
I am new to datastage 8.0.In teradata connector stage there is an option
called Acess Method ,under this we have two options one is immediate and other is bulk.Can any one help me in explianing all the diffrences between this two options and also please explain me when can we go for immediate and when can we go for bulk.
Thanks,
swathi.
Teradata Connector
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When you did a Search on DSXchange, what did you find about this particular property?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
With IBM Information Server (DataStage 8x), Teradata Connecter for Teradata Parallel Transporter (TPT / Teradata PT) joined the TD stages fleet.
Two access methods/modes of execution available in this stage:
1) Immediate - For Selector, Inserter... operators. Same as CLI interface/API. (No Load/Unload Utilities).
2) Bulk - For Load, Update, Stream and Export operators (i.e. fastload, multiload, tpump and fastexport respectively).
I have a Blog entry in which you might find more information on this.
Two access methods/modes of execution available in this stage:
1) Immediate - For Selector, Inserter... operators. Same as CLI interface/API. (No Load/Unload Utilities).
2) Bulk - For Load, Update, Stream and Export operators (i.e. fastload, multiload, tpump and fastexport respectively).
I have a Blog entry in which you might find more information on this.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>