#DateWhereItemComment
5112 Jul 2016 @ 06:38 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskChandra, you can use the Simba ODBC drivers. See the "ODBC Operator" chapter 10 in the TPT 15.10 Reference for more information.
5012 Jul 2016 @ 06:34 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskKarthik, yes, it's possible to load to multiple TD servers at the same time. You need to define different values for the TdpId attribute for each of the 2 Load operators in order to ...
4906 Jun 2016 @ 07:43 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to Disksamy@7, you can use either Progress DataDirect ODBC drivers or Simba ODBC drivers. The Progress DataDirect ODBC drivers are bundled with the TPT package starting with these TPT versions: 1. TPT 1...
4803 Jun 2016 @ 05:43 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to Disksamy@7, You need to use the TPT "tbuild" command to run a TPT script. For example: tbuild -f <TPT script> <TPT job name> See the "tbuild" command in chapter 1 of t...
4727 Jan 2016 @ 08:56 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskKamma1166, what is the source of the 6TB data? Is the source data on 1 or more disk files? Is the source data on an ODBC-complaint database, such as Oracle or DB2? Is the source data on a differ...
4615 Jun 2015 @ 10:21 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskHi Selvam, I have some questions: 1. Does "10 schema" mean "10 tables"? 2. Is the 200TB data on the 2 different AIX boxes? 3. Do you need to move the data from one Teradata ...
4509 Oct 2014 @ 09:36 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskWhen you use the OPERATOR templates, you do not need to define the schema, because TPT can infer the schema based on certain criteria in the job. See the "Simplifying Scripts with Operator Tem...
4401 Oct 2014 @ 11:21 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskVincent, you can use the TPT EasyLoader command called tdload. The TPT tdload command allows you to perform an export-to-load job (without landing data and without specifying the schema and without...
4330 May 2014 @ 12:07 PDTToolsIntroduction to the Teradata Parallel Transporter OperatorsVetri, The libodbcop.so file should be in the /opt/teradata/client/14.00/tbuild/lib directory. Check and send me the ldd output for the libodbcop.so file. Thanks.
4228 May 2014 @ 12:55 PDTToolsIntroduction to the Teradata Parallel Transporter OperatorsVetriSlevan, You might be not setting the LD_LIBRARY_PATH or might be pointing it to a wrong location.  The LD_LIBRARY_PATH should point to the lib folder of the DataDirect Drivers. Si...
4121 May 2014 @ 11:25 PDTToolsIntroduction to the Teradata Parallel Transporter OperatorsVetriSlevan, Yes, it's possible to connect only by using the ConnectString attribute (without the DSNName attribute). I have already provided you with a sample ConnectString attribute: '...
4019 May 2014 @ 11:58 PDTToolsIntroduction to the Teradata Parallel Transporter OperatorsVetriSlevan, Here is a sample of the ConnectString attribute: 'DSN=MYDSN;UID=username;PWD=Secret' You need to replace the MYDSN, username, and Secret values with your own values. Accord...
3915 May 2014 @ 05:50 PDTToolsIntroduction to the Teradata Parallel Transporter OperatorsVetriSlevan, What is the failure message? Your script should work if your ODBC configuration was setup properly. You need to make sure the ODBC configurations is setup properly before you ru...
3829 Apr 2014 @ 10:43 PDTToolsIntroduction to the Teradata Parallel Transporter OperatorsShyam, You can escape the single quote with two consecutive single quotes, like this: IN (''000362464WH'', ''20550K01A'');
3703 Dec 2013 @ 10:52 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskThe DataDirect ODBC driver is not on the TTU media. You can download the DataDirect ODBC driver and the installation/configuration guide from this link: http://www.datadirect.com/products/datadir...
3603 Dec 2013 @ 10:48 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskPablo, You can send me the tpt_privatelogs.txt file. My email address is: TL122451@teradata.com
3502 Dec 2013 @ 02:02 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskCan you provide the TPT job's private logs? You can use this sample command to retrieve the TPT private logs: tlogview -j root-70 -f "*" -g -o tpt_privatelogs.txt Run the command o...
3402 Dec 2013 @ 10:51 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskUse the DataDirect ODBC driver because TPT is certified with the DataDirect ODBC driver.
3320 Nov 2013 @ 09:24 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskWhen you say "I need load date from oracle to teradata in linux machine", I assume you meant "I need to load data from oracle to teradata in linux machine". If my assumption is...
3219 Nov 2013 @ 10:10 PSTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskBTEQ cannot extract data from DB2 tables because BTEQ can only interface with a Teradata database. You can use TPT to extract data from a DB2 table and load the data into Teradata without lan...
3129 Oct 2013 @ 06:16 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskVija, it's allocated from client system.
3029 Oct 2013 @ 04:19 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskVijai, Try to use the tbuild -h option to increase the shared memory size as follow:  tbuild -h 100M -f <TPT script> ... -h 100M means to use 100 mb of shared memory.
2901 Oct 2013 @ 11:46 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskWhat is the exact error message from the driver?  There are so many reasons that can cause the failure in connecting a session. Is the user account info correct?  Is the DSN set up corre...
2805 Sep 2013 @ 11:31 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskMake sure the DataDirect library path is in the library path environment variable.
2705 Sep 2013 @ 10:54 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskSuhail, The bit-ness should not have anything to do with performance. The performance should be similar.

Pages