Pages
![]() |
Hi,
I need to export few chinese and japanese characters stored in teradata to a file.
I have tried different options to export data through TPT but i am either not able to see the unicode characters in the generated file or i face the conflicting data length error.
19 Aug 2016
| 6 comments
,
|
![]() |
Hi,
18 Aug 2016
| 1 comment
,
|
![]() |
Hi,
02 Aug 2016
| 2 comments
,
|
![]() |
Using Teradata parallel transport with simplified syntax we get error TPT02638: Error: Conflicting data length for column(3) - "sr_abo_netto_do_oferty". Source column's data length (16) Target column's data length (8).
Source table:
02 Aug 2016
,
|
![]() |
I am having difficulty using tpt and bulk loading dates into a table. My define schema looks like:
07 Jul 2016
| 17 comments
,
|
![]() |
Error : TPT_INFRA: TPT02638: Error: Conflicting data length for column(5) - STATE. Source column's data length (16) Target column's data length (8). EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement
Code :
06 Jul 2016
| 3 comments
,
|
![]() |
Hi All,
28 Jun 2016
| 1 comment
,
|
![]() |
Any assistance would be welcomed. I cannot seem to put the Interval in a format that Teradata likes. The column data looks like "00 02:00:00.000000". We are extracting it from ORacle and loading to Teradata version 15.10. I am able to load most other data types no problem, but I cannot find the format needed to make this happy.
28 Jun 2016
| 4 comments
,
|
![]() |
Hi,
21 Jun 2016
| 2 comments
,
|
![]() |
If TPT Attributes
09 Jun 2016
| 7 comments
,
|
![]() |
Any help will be much appreciated. Thank you.
18 May 2016
| 6 comments
,
|
![]() |
HI All,
17 May 2016
| 5 comments
,
|
![]() |
Hi All, I create one ODBC Connection entry in ODBCINI file defined in .profile. OS is RHEL (Red Hat Enterprise Linux Server release 5.9 (Tikanga)). TPT Version is 14.10.00.08.
10 May 2016
| 30 comments
,
|
![]() |
Hi All,
21 Apr 2016
| 17 comments
,
|
![]() |
|
![]() |
Hi Friends,
19 Apr 2016
| 1 comment
,
|
![]() |
Hi everyone, im trying to load some data using TPT to Teradata table.
14 Apr 2016
| 1 comment
,
|
![]() |
Hi,
08 Apr 2016
| 7 comments
,
|
![]() |
Hi ,
20 Feb 2016
| 2 comments
,
|
![]() |
Dear Experts,
10 Feb 2016
| 4 comments
,
|
![]() |
#!/bin/ksh TBUILD <<EOF DEFINE JOB FILE_LOAD DESCRIPTION 'Load a Teradata table from a file' ( DEFINE SCHEMA Trans_n_Accts_Schema ( Account_Number VARCHAR(50), Trans_Number VARCHAR(50), Trans_Date VARCHAR(50), Trans_ID VARCHAR(50), Trans_Amount VARCHAR(50) ); DEFINE OPERATOR DDL_OPERATOR TYPE DDL ATTRIBUTES (
26 Dec 2015
| 2 comments
,
|
![]() |
I tried exporting the data using TPT in binary mode and it worked. File has been created.
05 Nov 2015
| 2 comments
,
|
![]() |
Hello All,
05 Nov 2015
,
|
![]() |
I have exported the data using TPT format as binary. File has been generated. How I can Validate my data with out loading into any of the table. Is there any way we can interpret the Teradata binary data file.
28 Oct 2015
,
|
![]() |
Hi,
15 Oct 2015
,
|
![]() |
Hi all, this is my first time here, and I hope anyone could help me.
30 Sep 2015
| 1 comment
,
|
![]() |
Running Teradata Parallel Transporter : Load Operator and ODBC Operator Version 15.10.00.01
24 Sep 2015
| 7 comments
,
|
![]() |
Hi All,
01 Sep 2015
| 2 comments
,
|
![]() |
Hi All,
**** 18:42:33 TPT10508: RDBMS error 3707: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between the 'USING' keyword and the 'DELETE' keyword.
27 Aug 2015
| 4 comments
,
|
![]() |
Hi, DEFINE OPERATOR File_Rd_Table TYPE DATACONNECTOR PRODUCER SCHEMA Table_S ATTRIBUTES (
21 Aug 2015
| 5 comments
,
|
![]() |
Hi,
04 Aug 2015
| 4 comments
,
|
![]() |
Hello.
14 Jul 2015
| 1 comment
,
|
![]() |
Hi ,
09 Jul 2015
| 16 comments
,
|
![]() |
Hello.
06 Jul 2015
| 2 comments
,
|
![]() |
How can I use a different target database (not TdpId) than what I declare in WorkingDatabase? I want the log and error tables to go to a work database, but the target table is in a different database.
30 Jun 2015
| 2 comments
,
|
![]() |
Teradata Parallel Transporter (TPT) provides a comprehensive set of features for loading data warehouses.
24 Jun 2015
,
|
![]() |
Hello All,
20 May 2015
| 1 comment
,
|
![]() |
|
![]() |
Hi Folks,
11 May 2015
| 1 comment
,
|
![]() |
Dears,
26 Apr 2015
| 5 comments
,
|
![]() |
Hello:
Sorry. I had posted this earlier, but I accidently unpublished it while looking at it.
16 Apr 2015
| 5 comments
,
|
![]() |
|
![]() |
Hi All,
26 Mar 2015
| 1 comment
,
|
![]() |
Hi All,
04 Mar 2015
,
|
![]() |
Hi, "1002"|"Manish"|"FIN"|"25000"|"1990-01-01"
16 Jan 2015
| 16 comments
,
|
![]() |
We are trying our first job with TPT and are having problems connecting to our source database. We are receiving this error...
09 Dec 2014
,
|
![]() |
Hi!
03 Dec 2014
| 8 comments
,
|
![]() |
|
![]() |
Hi All -
05 Nov 2014
| 5 comments
,
|
![]() |
Hello:
29 Oct 2014
| 3 comments
,
|