Teradata Connector

swathik · Post by **swathik** » Tue Jun 24, 2008 2:02 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 24, 2008 6:05 am

When you did a Search on DSXchange, what did you find about this particular property?

swathik · Post by **swathik** » Thu Jun 26, 2008 3:43 am

ray.wurlod wrote:When you did a Search on DSXchange, what did you find about this particular property? ...

I searched regarding this teradata connector but i didnt get any information?

JoshGeorge · Post by **JoshGeorge** » Thu Jun 26, 2008 5:45 pm

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.