All Forums

Covers the world of Teradata Tools & Utilities. This includes topics such as SQL Assistant, BTEQ, TPump, FastLoad, TPT, etc. For articles, blogs and more, see the Tools section of the site.

You must login to post to the forums.
Seeking Advice On Low Latency (Near Real Time) Loads using TPT and CDC Topic by DW4Life 16 hours ago

Currently faced with an envionment that looks as such:
Source: AS/400
Target: Teradata
ETL Tool: Informatica
 
Requirement: Low Latency / Near Real Time Data Availability

54 views
4 replies, 4 hours ago
Limitation of Reading number of Fields in TPT Topic by gbindra 12 hours ago tpt

Hi,
 

13 views
0 replies
TPT OLE DB and TPT moving to version 15 Topic by brcriss 1 day ago

I uninstalled all old versions and installed the 15 Client tools.  I installed this: OLE DB Provider for Teradata and I can no longer find the OLE DB wizzard.  When I try to open my amj files, there is no program. 

30 views
1 reply, 18 hours ago
EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement Topic by Minatkumarverma 06 Jun 2014 tpt, EXPORT_OPERATOR, UTLITIES, tools

Hi ,
The subject might be old, but I was unable to figure out my solution, so please take a look once.
Trying to TPT using the below Script :

532 views
5 replies, 1 day ago
Archive all tables with data Topic by k3na 5 days ago

Hi all!
May be a very simple question.. I want to dump the current state of the Teradata database. To do it, I use arcmain and the following script:
ARCHIVE DATA TABLES (dbname),
RELEASE LOCK,
FILE=ARCHIVE;
However, this script archives tables without data. How could I dump all objects with their content? 
Many thanks!

78 views
2 replies, 1 day ago
Parameters and teradata Dynamic SQL Topic by catrepan 4 days ago dynamic sql; parameters; stored procedures;

I'm trying to use a parameter within my dynamic sql query, but just can't get it to work. I simplified my code to highlight only the part I'm struggling with.
I first create 't1', to which I insert the record.

create volatile table t1 as(
select date '1900-01-01' as date_col
)with data on commit preserve rows;

38 views
0 replies
TDSQLA 14.10 - Cut & Paste Issue Topic by TDW 5 days ago SQLA 14

Hello,
I can no longer call myself a newbie (2 year anniversary with my job), but I am still green on some issues.
I searched this site - as well as the Internet - and could not find an answer.

48 views
0 replies
TPT scripts Topic by raju197402 1 month ago

Currently I have TPT scripts which transfers data from schema1 (Teradata  box1) to schema2 (Teradata box2). There is a plan to move the contents of Teradata Box2 to Oracle.
Will the TPT scripts written can be reused to tranfer data to Oracle. If so does it require any major changes to be done to make it work for Oracle. If not what is the alternate way?
Thanks,

184 views
4 replies, 6 days ago
TPT - BUFFERMAX error Topic by arfsoft 24 Apr 2014 TPT 19003, tpt, BUFFERMAXSIZE

Hi all, I'm pretty new to using TPT and am working with Version 14.00.00.07.  In the last week or so I have been finding that almost all of my jobs involving a simple load from one csv into one table are failing.

162 views
3 replies, 6 days ago
ABU 14.10 table restoring error Topic by calvinlkn 1 week ago

Hi, 
I have installed ABU14.10.
-- To backup a table for testing by option "Backup Selected Objects" , tried to backup particular table for testing.
Steps :
1. Select option "Backup Selected Objects" for backup testing table test123
2. Drop the table test123.

43 views
1 reply, 1 week ago
Facing TPT error while lading data from flat file to Teradata Topic by richa.prvr 1 week ago

Hi,
Below is my TPT script to load data from flat file to Teradata 15.00.
DEFINE JOB LOAD_TPT_TEST2
DESCRIPTION 'LOAD A TERADATA TABLE FROM A FLAT FILE'
(
DEFINE SCHEMA FILESCHEMA
(
EID  INTEGER,
EMPNM VARCHAR(10)
);
DEFINE OPERATOR DATACONN_C2
TYPE DATACONNECTOR PRODUCER
SCHEMA FILESCHEMA
ATTRIBUTES

84 views
3 replies, 1 week ago
Getting error on Fastload..."nvalid state for Load" Topic by vniri.teradata 10 Mar 2009

Hi , I am getting the following error when doing a fast load.**** 15:21:00 RDBMS error 2635: Error tables are invalid OR TFL_SALE is in an invalid state for Loaddoes this mean the is a fastload lock on the table.Need help in solving this...Thanks Nick

4953 views
4 replies, 1 week ago
Restarting Fastload if we have error with the source data file Topic by ppad001 24 Mar 2013 fload

Hi,
I had encountered today a failure with fastload. There was some issue with the source file for which the fastload got paused. I corrected the data and restarted the run, but it didnt succeed.
I got the error:
**** 21:36:29 RDBMS error 2634: Existing ERROR table(s) or Incorrect
              use of unit_Inf  in  Fast Load operation.

1402 views
2 replies, 1 week ago
Teradata FLOAD error table 1 creates unwanted newlines in Dataparcel data. Topic by yugeshshrestha 2 weeks ago #Fastload #Dataparcel #FLoad error table

I have a fastload utility to load data from txt file into Teradata table. I am trying to get the data from Teradata error table 1 into a structured format in a separate file. But Currently, the data generated from each Data Parcel for each row inserts a new line character after every date type data.
For eg: If my source file has following data

100 views
3 replies, 1 week ago
TTU 15 Installed, SQL Assistant Error Topic by robinsu 23 May 2014 ttu 15

After install TTU 15, The SQL Assistant show Error:
=== Entry Point Not Found ===
The procedure entry point __crtInitializeCriticalSectionEx could not be located in the dynamic link library MSVCR110.dll
 
OS is Windows 7.
Are you have similar experience on TTU 15? Please advise me and thanks a lot.

172 views
1 reply, 1 week ago
TPT 64bit on Windows 7 sits on FINISH indefinitely Topic by vnaicker 30 May 2013 TPT 64bit

I have TPT 14.10 64bit installed with PATH pointing to JRE 32bit. When I define a job, it goes until FINISH but does nothing when clicked. I have Run Job Now checked already. Removing the check from there does not do anything either (save). I have to only cancel, when I get a warning that the job is not saved. What am I missing? My machine is Windows 7 (64bit).
Thanks.
Venky

1531 views
14 replies, 1 week ago
Teradata Decision Experts (TDE) Topic by maniamenon 1 week ago

Can anyone help me some documentation on Teradata Decision Experts (TDE)?
Mani

39 views
1 reply, 1 week ago
Error Starting SQL Assistant v14.10.0.4 Topic by BkAZ 1 month ago special directory, My Documents, sql assistant

I cannot start SQL Assistant, and the error message is:

System.IO.DirectoryNotFoundException: Could not find special directory 'My Documents'.

 

129 views
2 replies, 1 week ago
Error Starting SQL Assistant v13.10 Topic by stansle 06 Apr 2012 sql assistant v13.10, special directory

I receive the following error when starting SQL Assistant v13.10 in Windows 7 Professional. 

Could not find special directory 'My Documents'.  Unexpected Error. ...

Has anyone seen this error and can assist.

Thanks.

Len

 

4439 views
4 replies, 1 week ago
DBSCONTROL dont display data Topic by gdvaldesh 1 week ago dbscontrol display

Hi, a few days i opened dbscontrol to view a flag, "GENERAL DISPLAY" and showed me the information correctly, but now that I try to enter does not show me anything, the command continues processing but never ends.

 

The other commands continue works (MODIFY, QUIT, HELP), DISPLAY command only don't works.

 

41 views
1 reply, 1 week ago
TPT - Oracle Date to Teradata Timestamp(0) Topic by jgleaso 17 Apr 2007

I just upgraded from ttu8.1 to ttu8.2. I am loading a Teradata table via the TPT wizard from an Oracle table via fastload (load). When selecting the source table and fields, the tpt wizard does not know how to define the Oracle date field and requires me to edit the definition from a dropdown list. Has anyone else experienced this?Every combination that I have used from the dropdown list has failed when trying to load to a Teradata timestamp(0) field. Has anyone else had any success moving data from and Oracle DATE to Teradata TIMESTAMP(0)? If so, a sample script would be greatly appreciated! I suspect it might be an ODBC problem. I am selecting the 'Oracle Tables' option from the source versus the 'ODBC DSN' option. The 'ODBC DSN' option always me to see the source tables in the schema I select, but fails when I try to access the fields in any table.Thanks in advance for any input you may provide,jgleaso

23583 views
5 replies, 1 week ago
TPT Export Error TPT01403 Topic by stat 2 weeks ago TPT Errors

Hello, 
I am trying to export data from a Teradata table wm_ad_hoc.Table1 using TPT to a delemited file format in  UNIX. That table has around 11 million rows and the export works fine using BTEQ.
But when used TPT, only 8 million rows got exported and then errored out with the message

61 views
1 reply, 2 weeks ago
Downloads from downloads.teradata.com are blocked by Norton Topic by satrn_grl 2 weeks ago

I've tried to download TTU 15 Installer from https://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package
which leads to d289lrf5tw1zls.cloudfront.net
 
Which is blocked by Norton:
http://safeweb.norton.com/report/show?url=d289lrf5tw1zls.cloudfront.net

68 views
3 replies, 2 weeks ago
Fastload to non-empty table Topic by padthai_noodles 1 month ago

Hi,
What is the exact reason we can fastload to non-empty tables. I know we cant update the existing tables but what stops in just inserting to the non-empty table.
Regards,
Am

182 views
3 replies, 2 weeks ago
BTEQ Data Truncation while Exporting Topic by stat 2 weeks ago bteq export

Hello,

 

113 views
4 replies, 2 weeks ago

Pages