Pages
![]() |
30 Sep 2013
| 2 comments
,
|
![]() |
Dear All,
12 Sep 2013
| 7 comments
,
|
![]() |
We are now using TPT and we have a requirement to load multiple files at the same time. In the beginning we use the (*) in the file name but we have a challenge of using the wildcard character (*). Anyway to use TPT load data file contain regular expression such as ABC_AAA_[0-9].dat, ABC_AAA_BBB_[0-9][0-9].dat?
02 Sep 2013
| 5 comments
,
|
![]() |
Teradata Parallel Transporter, a high-performance parallel and scalable extract and load utility for Teradata, allows users to launch ETL processes that interact with various sources and targets by creating and submitting TPT job scripts.
15 Aug 2013
,
|
![]() |
Hi everyone. I'm trying to load SQL server tables to Teradata14 using OleDB via TD's OleLoad tool. I'm having trouble with attributes defined as VARCHAR(MAX) in SQL server - it seems that this is a LOB data type. Here is the script that OleLoad is generating:
30 Jul 2013
| 4 comments
,
|
![]() |
Greetings Experts, What is the basic difference between the instances and sessions in TPT. If I declare a Maxsessions attribute for a operator to be 10 over a 10 AMP system, and the consumer operator uses all 10 sessions (as producer is able to keep the consumer busy)
30 Jul 2013
| 13 comments
,
|
![]() |
Hello,
26 Jul 2013
,
|
![]() |
|
![]() |
Hi,
15 Jul 2013
| 13 comments
,
|
![]() |
I am trying to load data from hadoop to Teradata using tpt.
11 Jul 2013
| 5 comments
,
|
![]() |
The article "Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00" has a passing comment that there is a possibility to change TPT handling of zero-length strings:
08 Jul 2013
| 2 comments
,
|
![]() |
Hello Everyone,
04 Jul 2013
| 1 comment
,
|
![]() |
Is there a way, within a TPT module, to accept in OS environment variables?
03 Jul 2013
| 4 comments
,
|
![]() |
Hi,
30 Jun 2013
,
|
![]() |
I have the requirement, where for one of the client I need to incorporate the filename in Teradata table. Client has Teradata 13 machine. We have a fixed width source flat file and we are using TPT script in "TEXT" format.
27 Jun 2013
,
|
![]() |
Hello,
01 May 2013
| 16 comments
,
|
![]() |
Hi All,
11 Apr 2013
| 1 comment
,
|
![]() |
Is there any possible to load IBM EBCDIC file using TPT? There is a EBCDIC file in the mainframe, we are trying to load the file to teradata which installed in the Linux server, is there any possible using TPT connected to mainframe and load the file directly?
16 Mar 2013
| 4 comments
,
|
![]() |
Hello Teradata experts,
25 Feb 2013
| 7 comments
,
|
![]() |
|
![]() |
Hello,
08 Feb 2013
| 1 comment
,
|
![]() |
We are Informatica Powerexchange for TPT. When we tried to load a table with 140 columns and row length of 55k, TPT connection is throwing invalid row length error. However same is working fine with relational connection.
29 Jan 2013
,
|
![]() |
Can someone please explain the usage and the proper syntax for the the DEFINE SCHEMA 'name' DELIMTED 'tablename'; introduced in TPT 14.00 reference manual diagram on page 62 / Nov 2011 ?
25 Jan 2013
| 1 comment
,
|
![]() |
Hi All,
I have to write a TPT script to move data from teradata table to flat file in unix. I know we should use a export operator as producer and a dataconnector as consumer but i have somethings to clarify whether the following is possible in writing TPT in unix.
21 Jan 2013
| 9 comments
,
|
![]() |
|
![]() |
Hi everybody,
11 Dec 2012
| 3 comments
,
|
![]() |
I am getting below error while trying to connect to Oracle DB using DataDirect 7.1 ODBC drivers from TPT script. I am able to test the connection using the example executable program in DataDirect and it works fine.
10 Dec 2012
| 9 comments
,
|
![]() |
Hello. I need to export large numbers of tables to CSV files for customer deliverables. I am working under Teradata 13.10. For VARCHAR fields, I need to include a Character String delimiter (double-quote) in the CSV. I have created a tbuild/TPT export script as described in Example 10 of the TPT User Guide, but cant find a way to get the string delim
10 Dec 2012
| 8 comments
,
|
![]() |
This article describes how to preserve data integrity when a Teradata Parallel Transporter (Teradata PT) export to stream job restarts.
04 Dec 2012
| 6 comments
,
|
![]() |
Greetings!
28 Nov 2012
| 1 comment
,
|
![]() |
Teradata Parallel Transporter is the premiere client load/unload tool, providing parallel extraction and loading of critical data.
27 Nov 2012
,
|
![]() |
Hi, My TPT script gets data from some pipes and load using the UPDATE operator, and for a few weeks everything worked well.
But, at 3 days I'm have getting this error in the middle of load process:
06 Nov 2012
| 2 comments
,
|
![]() |
Hi,
30 Oct 2012
| 3 comments
,
|
![]() |
Hi Teradata gurus,
19 Oct 2012
| 6 comments
,
|
![]() |
Hi,
11 Oct 2012
| 2 comments
,
|
![]() |
Hi,
14 Sep 2012
| 2 comments
,
|
![]() |
Does anyone have a template script for TPT that extracts data from Sybase?
06 Sep 2012
| 1 comment
,
|
![]() |
I have a proble with TPT, and never pass through this error. Script:
15 Aug 2012
| 12 comments
,
|
![]() |
Hi, I'm using a TPT with LOAD_OPERATOR to load a flat file (Format='Text') into an empty table. I'm receiving the following error:
10 Aug 2012
| 1 comment
,
|
![]() |
Dear All, I'm new using Teradata, currently i'm facing error TPT10507: CLI Error 215: MTDP: EM_CONNECT(215): Error found in local machine during connect. while using TPT with Data Connector and Update Operator. Any suggestions what kind error is this ?
Regards, sroctadian
07 Aug 2012
,
|
![]() |
Hi, I got to know that I can use TPT ODBC Operator to select data from another ODBC DB and then load that data into TD DB, using the LOAD Operator.
31 Jul 2012
| 4 comments
,
|
![]() |
Hi there, Can TPT be used to export ASCII data as UTF-8... ? Meaning, the data stored in the TD DB table is ASCII, but we want a flat file export that is in UTF-8 Format. Is this possible? As far as I have seen in the TPT User Guide, it appears that the character set of data and export file should be the same.
31 Jul 2012
| 2 comments
,
|
![]() |
Hi everyone,
17 Jul 2012
| 2 comments
,
|
![]() |
Hi everybody, In the current implementation of our load scripts with multiload and tpump we are using the system variables holding the result count(&sysinscnt, &sysupdcnt, &sysetcnt, &sysuvcnt) for logging and further processing.
16 Jul 2012
| 16 comments
,
|
![]() |
Hi everybody, I'm currently evaluating the use of TPT for load jobs in a DWH environment. One of the basic problems is that we often have a random number of blanks at the end of the data row in the input file. This can't easily be changed because the files are delivered from several different systems.
12 Jul 2012
| 2 comments
,
|
![]() |
Hi Teradata Masters, I'm trying to provide data to be consumed by a Load Operator in my TPT script throught a named pipe. DEFINE OPERATOR PIPE_READER()
27 Jun 2012
| 8 comments
,
|
![]() |
Hi , I have a smiple mapping where I take data from Oracle database ,use expression transformation to add certain parameter values and then push it to teradata box. Now, it is running fine when I use relational connection however whe I use TPT connection it shows all rows being processed but nothing gets inserted into table.
22 Jun 2012
| 4 comments
,
|
![]() |
|
![]() |
HI, -With 32 bit TPTAPI libraries (TelApi 13.10) I could connect and fetch the data from Teradata database (13.0).
18 Apr 2012
| 9 comments
,
|
![]() |