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.
Can TPT be used to load file with 10M records of 3500 attributes ??? Topic by raghavan.tce 13 Jun 2016 TPT Max columns, huge file processing, TPT Loader

Hi, I have a pipe delimited file with 3500 attributes each of length varying between 2-5 and max length of the file records is 6500. No. of records is about 10Million and file will be landed to unix server. Below are my queries :
a.  Is TPT best tool for loading such a huge file ?

166 views
1 reply, 3 years ago
TD utilities and JAVA. Topic by mayanktiwari 30 Apr 2013

Hi All,
I am developing a code on Core JAVA. But I dont know how to Execute the code with the help of the TD Utilities on UNIX.
Is there any facility/add-in provided by TD by we can do this.
Please respond back if anybody knows about it.
 
Thanks & Regards,
 
Mayank

2282 views
9 replies, 3 years ago
Arcmain Topic by qasim 12 Jun 2016

Hi All,
 Kindly anyone can advise me from where and how to install Arcmain?

230 views
2 replies, 3 years ago
BTEQ Import Latest Flat File Topic by International83 10 Jun 2016

Hello experts,

99 views
0 replies
TPT Wizard Topic by Roopalini 09 Jun 2016

Forum - 
I installed TPT wizard 15.00 version recently and any job that I try to run is giving me the below error. 
Completed with unexpected status from tbuild (-1,073,741,515). Could this be an installation issue? 
Thanks
 
 
 

150 views
1 reply, 3 years ago
What are the new features and major bug fixes in TTU 15.10? (in comparison with TTU15.00) Topic by upriser7 08 Jun 2016 ttu, 15.10, 15.00, upgrade

We are planning to upgrade from TTU 15.00 to TTU 15.10 but before doing so , I wanted to know whether there any major bug fixes and any new features in TTU 15.10 release when compared to 15.00 release. I searched online regarding this but couldn't find anything. Can anyone help me with this?

450 views
1 reply, 3 years ago
Installing tools on Ubuntu Topic by skunkwerk 02 Jun 2016

How do I install the tools on Ubuntu?  Why can't Teradata just provide this as a single-line apt-get command instead of forcing developers to spend an hour struggling with this?
 
I've tried all of this, but at the end I still cannot run tbuild:

 

sudo apt-get install alien dpkg-dev debhelper build-essential

 

237 views
1 reply, 3 years ago
Error locating in SQL Assistant 15 Topic by XLTMike 15 Apr 2016

We are writing queries against our data to find data quality issues. Currently, there are about 500 and have quite a few more to do. 
We have a request for high level count of failures for each one. With some pixie dust, we generate a Select ID#, BU, Count(*) for each of these.

305 views
3 replies, 3 years ago
where to download the installation for Teradata Schema Workbench Topic by wenjin 15 Apr 2014

Do you know where to download the installation for Teradata Schema Workbench?
Thank you!
 

958 views
2 replies, 3 years ago
EF5 + Teradata + views Topic by imgregduh 06 Jun 2016 schemaloader, EF5

I am trying to use EF5 with teradata to include my views to the edmx and I cant get it to appear in the model wizard.  I have read the workaround to get views to appear in the wizard but when I open the schemaloader.exe it immediately close before I am able to enter a command.

67 views
0 replies
Encrypted logon file Topic by ahhmedbilal 02 Jun 2016

Hi, 
Is it possible that logon.txt file in below command be encrypted using ccrypt function in linux and how can we use that encrypted file in bteq for example. 
.run file logon.txt
Thanks
 

170 views
1 reply, 3 years ago
Fast Export Error - UTY8400 Error determining ESS support, code = 224 Topic by kpedit 03 Jun 2016 #FASTEXPORT #FEXP

Hi All,

305 views
1 reply, 3 years ago
TPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>'; Topic by chandrajit.santra85 18 Jun 2014

Hi,
I am trying to create one generic TPT script for data copy purpose and facing some issues with DEFINE SCHEMA syntax. Details are explained below. 
Environmental Details:
Teradata PT Version: 14.10.00.02
OS: Linux

5063 views
27 replies, 3 years ago
ASCII value of the delimiter in TPT Export Operator Topic by Arpan.Roy 21 Apr 2016 tpt, export operator, delimiter

Hi All,
Is there any way to pass ASCII value of character in TextDelimiter for TPT Export Operator? I want to export  a "TAB" delimited file. But when I'm giving tab a separator, it's taking space as delimiter. So if we can give ASCII character instead of actual character, it might produce the export file with tab as delimiter.
Below is my tpt control file:

1043 views
17 replies, 3 years ago
Creating ODBC DSN for Teradata Database Topic by mabe 22 Aug 2007

Hi, Im new to Teradata database. I have installed Teradata 8.1 from the demo cd.I created a new database in Teradata Administrator and tried creating a odbc DSN for my created database.But im unaware of what to provide in the Authentication field of Teradata ODBC Driver.

27234 views
6 replies, 3 years ago
Using TPT templates to copy more than one table in a script. Topic by padhia 26 May 2016

I am using following TPT script to load two tables from another Teradata system. 

271 views
3 replies, 3 years ago
Strange production scenario Topic by m_v_anita 01 Jun 2016

Hi , 
 
We have encountered a strange data issue in Prod. We are trying to load a history table using BTEQ. 
The history table has 

PRIMARY INDEX( ACCT_NB )

UNIQUE INDEX( ACCT_NB ,EFF_DT )

 

 

84 views
1 reply, 3 years ago
report with different numbering expected * BTEQ * Topic by Luck 26 Apr 2016 bteq

Good afternoon.

I'm trying to export the query result below by BTEQ. I am using the following script.

 

SELECT DATABASENAME AS "Banco de Dados"

,SUM(CURRENTPERM) AS "Ocupado"

,(MAX(CURRENTPERM) * 72) AS "Ocupado_comskew"

,SUM(MAXPERM) AS "Alocado"

,Alocado - Ocupado AS "Disponível"

160 views
2 replies, 3 years ago
BTEQ Import Invalid Date Issue Topic by taruntrehan 28 Mar 2014 bteq, invalid date, import data

Hi All,
I am trying to port data from a flat file to TD via BTEQ.
The table definition is :

2277 views
3 replies, 3 years ago
TPT Data Streams Topic by toadrw 29 May 2016 #TPT, #DataStream, #ODBCOperator, #LoadOpertor

Hello:
I have a quick clarification on the TPT Architecture.
I'm executing a TPT script on my local PC which is using the ODBC Operator to pull data from a non-Teradata data source.  I'm them loading the data in Teradata using the Load operator.

151 views
1 reply, 3 years ago
TPT03036: Length must be a positive integer value Topic by DiEgoR 30 May 2016

There is a following error message from a tbuild execution:

164 views
3 replies, 3 years ago
Executing multiple TPT scripts simultaneously will yield to better perfomance? Topic by archana_2016 16 May 2016

Hi
Can i execute multiple scripts with different producers(source tables) and different consumers(target files) simultaneously to get a better perfomance.
 
Thanks in advance

306 views
7 replies, 3 years ago
Python module for Teradata Topic by srinath29 31 May 2016 teradata python module, python, # teradata

Hi
I have installed python from Anaconda Continuum and later installed teradata module

conda install teradata

It installed successfully then ran the hello world program like this

418 views
0 replies
SQL Assistant - Copy to Notepad Topic by yenkoz28 21 Apr 2016 SQL Assistant - Copy to Notepad

Regarding the File menu option "Copy to Notepad", is it possible to replace Notepad with a different text editor, such as Notepad++ (NPP)?

208 views
2 replies, 3 years ago
Need help in using SQL Assistant Topic by prasanth225 20 May 2016

Hi All,
 
Two questions-
1. Our team is connecting to DB using SQL assistant. We connect to both dev and prod. Recently one of our team member by mistake connected to prod and deleted data thinking that he is doing it in dev. We would like to avoid such human mistakes. Any ideas in this regard are much appreciated.
 

333 views
5 replies, 3 years ago

Pages