Hi All,
Can anyone please let me know the extra features of the teradata connector ?
Im not sure whether the fix released by IBM is for server , parallel or both.
Can anyone please give some insight about the connector on how different is it from teradata API Stage
Cheers!!!
Alan
Teradata connector for Datastage
Moderators: chulett, rschirm, roy
Re: Teradata connector for Datastage
HI is your problem solved ,
We also having same issues with DS v8.0 connection issue with DB2 .
is there any updates with IBM.
Thanks
Rama
We also having same issues with DS v8.0 connection issue with DB2 .
is there any updates with IBM.
Thanks
Rama
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
Hi Alan,
The new Teradata Connector Stage is available only for Parallel Jobs and has two modes of execution:
1) Immediate - Utilizes CLI interface to communicate with TD (No Load/Unload Utilities are used). In this mode, the functionality is same as API stage.
2) Bulk - Utilizes the Teradata Parallel Transporter protocol to load into/unload from TD.(Fastexport, Fastload, Multiload, TPump are now present as operators in TPT and all of them can be invoked through this stage). In this mode, the it delivers the functionality of both Teradata Multiload/TPump and Teradata Enterprise Stage.
Hope it helps.
The new Teradata Connector Stage is available only for Parallel Jobs and has two modes of execution:
1) Immediate - Utilizes CLI interface to communicate with TD (No Load/Unload Utilities are used). In this mode, the functionality is same as API stage.
2) Bulk - Utilizes the Teradata Parallel Transporter protocol to load into/unload from TD.(Fastexport, Fastload, Multiload, TPump are now present as operators in TPT and all of them can be invoked through this stage). In this mode, the it delivers the functionality of both Teradata Multiload/TPump and Teradata Enterprise Stage.
Hope it helps.
Teradata Connector Stage
Hi,
Thanks a lot on the update.
I guess I will be able to work on it this week..since IBM is working on installing the patch...
..and it helped me in updating the client about a lil info.
Regards,
Alan
Thanks a lot on the update.
I guess I will be able to work on it this week..since IBM is working on installing the patch...
..and it helped me in updating the client about a lil info.
Regards,
Alan
DS_FocusGroup wrote:Hi Alan,
The new Teradata Connector Stage is available only for Parallel Jobs and has two modes of execution:
1) Immediate - Utilizes CLI interface to communicate with TD (No Load/Unload Utilities are used). In this mode, the functionality is same as API stage.
2) Bulk - Utilizes the Teradata Parallel Transporter protocol to load into/unload from TD.(Fastexport, Fastload, Multiload, TPump are now present as operators in TPT and all of them can be invoked through this stage). In this mode, the it delivers the functionality of both Teradata Multiload/TPump and Teradata Enterprise Stage.
Hope it helps.
Hi guys,
Just wanted to bring up this thread as we're having some difficulties using the Teradata Connector in DataStage.
Basically, when do you use Immediate and when do you use Bulk mode.
Right now, we're under the impression that the Bulk mode is best used for loading a bigger # of records and use Immediate for a smaller number.
But we're having some performance problems.
Right now it seems using Multiload Stage is faster than using the Teradata Connector Stage (Bulk/Immediate). But theoretically, since Teradata connector (bulk) is making use of TPT load utility.. it should run faster than Multiload Stage.
Any ideas?
Just wanted to bring up this thread as we're having some difficulties using the Teradata Connector in DataStage.
Basically, when do you use Immediate and when do you use Bulk mode.
Right now, we're under the impression that the Bulk mode is best used for loading a bigger # of records and use Immediate for a smaller number.
But we're having some performance problems.
Right now it seems using Multiload Stage is faster than using the Teradata Connector Stage (Bulk/Immediate). But theoretically, since Teradata connector (bulk) is making use of TPT load utility.. it should run faster than Multiload Stage.
Any ideas?