How to install Teradata on UBUNTU
Topic by nmkiran
26 Aug 2011
*** imp for interview
Hello everybody,
Nice to see many solutions with different options. I have teradata recently on windows, I like to install and do practice on linux too. Kindly help how to do. Thanks for understanding.
|
10185 views
|
7 replies,
4 years ago
|
Fast load failure with return code 12
Topic by naresh236
28 Jul 2016
Hi All,
Recently we have upgraded from Teradata 14 to 15 since when we have started encountering an error in one of our fastloads.
The issue is we have a variable length file which is delimited by tab.
|
414 views
|
1 reply,
4 years ago
|
Linking/Joining Different Databases in Teradata
Topic by smarti01
16 Feb 2016
I am trying to link/join 2 different databases from 2 different servers in a query, but I can't seem to get it to work What is the trick?
|
529 views
|
6 replies,
4 years ago
|
Error retrieving TWB root directory: Success (0)
Topic by Joxo72
13 Jun 2016
Hi,
When executing a script directly from the unix command line it works.
When doing so via crontab i get this error;
Error retrieving TWB root directory: Success (0)
Can you explain what the error actually means and why it might be recieved when executing an otherwise succesfull script via crontab?
Version:
|
217 views
|
0 replies
|
Return XML from REST API.
Topic by gokul_ifs
06 Jun 2016
Hi,
I am using REST API for driver less real time connectivity. My application passes input to a macro in JSON format and get returns output in JSON format.
|
206 views
|
0 replies
|
Unity Source Link
Topic by Raja_KT
16 Jan 2014
DBCForeign.CreateLink!!!! will it accept to all DBs and even HIVE, HBASE, SQOOP etc?
Thanks and regards,
Raja
|
2002 views
|
8 replies,
4 years ago
|
BSD compatibility
Topic by Jane98
25 May 2016
Hi,
Is it possible to connect to a Teradata database from BSD (OpenBSD, FreeBSD, NetBSD)? The official Teradata web site has ODBC drivers for Linux, Solaris, AIX, HP-UX, and Mac. So I guess BSD is not officially supported, but would any of these drivers work in BSD?
http://downloads.teradata.com/download/connectivity
|
206 views
|
1 reply,
4 years ago
|
BTEQ - DELIMITER
Topic by dineshks
04 May 2016
How to give '10'xc (hexadecimal 10) as delimiter in BTEQ script.in Unix it should be represented as ^p ?
|
989 views
|
4 replies,
4 years ago
|
|
3320 views
|
5 replies,
4 years ago
|
TPT - Load Operator consumes from a named pipe provided by a JNI process
Topic by EricSantAnna
27 Jun 2012
java, tpt, teradata parallel transporter, pipe, jni
Hi Teradata Masters,
I'm trying to provide data to be consumed by a Load Operator in my TPT script throught a named pipe.
My DATACONNECTOR Producer: (all runs local on Windows)
DEFINE OPERATOR PIPE_READER()
DESCRIPTION 'Define opcoes de leitura de arquivos'
TYPE DATACONNECTOR PRODUCER
SCHEMA T701S020_SCHEMA
ATTRIBUTES
(
|
9349 views
|
8 replies,
4 years ago
|
TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11
Topic by tiiiway
16 May 2016
TPT UPDATE
I have received the error below when using the ODBC.
Teradata Parallel Transporter Version 14.00.00.04
TPT_INFRA: Semantic error at or near line 145 of Job Script File 'PersBEPS_PERSONA_BEPS.tpt':
TPT_INFRA: TPT03276: Could not resolve column reference 'NumeroDocumentoPersona. Expression is rejected.
|
295 views
|
0 replies
|
TPT 15.00.00
Topic by anand82
05 May 2016
#TPT #flat file
Hi,
I am using TTU 15.00.00 and tried to export a teradata table into a FLAT FILE. I had no issues for some tables. But, I had the below error while extracting the data to a delimited flat file.
TPT_INFRA: TPT02638 : Error conflicting data length for column (10) XXXX . Source columns data length (16) Target column data length (8).
|
398 views
|
1 reply,
4 years ago
|
Creating a generic TPT script without specifying columns
Topic by Ismailask
04 May 2016
generic TPT, Define schema
Hi All,
Is there any method in TPT to build the script without defining the schema of the tables so that I can build one generic script and pass the tablename and databasename as parameter .
I'm trying this:
DEFINE SCHEMA Tables_SCHEMA @SourceTableName;
OR
|
186 views
|
0 replies
|
TARA Backup Performance
Topic by DannyChin
09 Mar 2016
Are there any performance differences between running 1 backup job using 8 streams and 8 concurrent jobs using 1 stream?
|
336 views
|
2 replies,
4 years ago
|
TPT API buffer mode format??, indicate?? a few infomation....
Topic by Kahan
02 May 2016
returnValue = conn->GetEvent(TD_Evt_BufferLayout, &dataptr, &datalen);
if ( returnValue < TD_Error && returnValue != TD_Unavailable ){
buffersize = *((int*)dataptr);
rowheadersize = *((int*)(dataptr + sizeof(int)));
rowlengthsize = *((int*)(dataptr+2*sizeof(int)));
|
190 views
|
0 replies
|
Set Default week start day as Friday in Teradata
Topic by keerthi1987
01 May 2016
Hi,
We are generating weekly based customers report in application.In that previously we have used default in teradata,but We need to set defualt week start day as Friday that should be globle. Example In Sql server, SET DATEFIRST 5; SELECT DATEPART(WEEK,CAST('2015-01-01'AS DATE)) AS WeekNumber From UserTable;
|
203 views
|
1 reply,
4 years ago
|
Error handling in MLOAD
Topic by user1973
28 Apr 2016
I am trying to use mload for loading data into teradata. Few rows in my file has column size errors. Log file did not show all the rows for the colimn size erros . My constraint violation error table was also empty along with my work table. My log table had few rows.
How i can know which rows did not get loaded? Why my constraint violation error table was empty?
|
205 views
|
0 replies
|
Bug with TPT Update Operator
Topic by Robinhood
28 Apr 2016
Hi Steve ,
Eariler we was using TTU 13.10 version ,our jobs were running perfectly through Informatica in which we are using TPT connection .After upgrading TTU from 13.10 to 14.10 ,now our jobs are failing with Transaction aborted due to deadlock .Is there any issue with TTU 14.10 .We are not able to figure out the issue .
|
208 views
|
0 replies
|
Silent install. bat
Topic by bluenoes
23 Sep 2015
I am trying to carry out a silent isntall of teradata 15 for deployment via SCCM.
The documentation refers to a silent_install.bat file to detail components required for the install, but this file does not exist in the download.
Please can anyone advise where to obtain the silent install file?
|
574 views
|
1 reply,
4 years ago
|
How to replicate the values
Topic by kumarvaibhav1992
17 Apr 2016
#database #teradata
Hi All,
I want to Write a query to duplicate each row based on the value in the repeat column? The input table data looks like as below
Products, Repeat
----------------
A, 3
B, 5
C, 2
|
242 views
|
2 replies,
4 years ago
|
Adding column headers to TPT export files - FILE_WRITER/EXPORT_OPERATOR operator
Topic by dsampath
18 Apr 2016
Hi,
I am using EXPORT_OPERATOR() and FILE_WRITER() operators to export data from table into a CSV file.
Is there an option that I can enable in either of these two operators to include the column header in the output file. This option ususally exists in all client tools and ETL tools.
|
352 views
|
0 replies
|
How to use Loops
Topic by kumarvaibhav1992
09 Apr 2016
#database #teradata
Hi All ,
I have my table like this :
Id Name Country
1 Vaibhav India
2 Amit UK
3 Pranav US
I want to read all the records by the max number of records present using count(id) ,3 in this case and just increment the counter by 1 for each records processed .Simultaneously i wanted to print the result of my counter variable.
|
299 views
|
2 replies,
4 years ago
|
TPT Wizard Not Showing columns in Job Source
Topic by Natu
09 Apr 2016
Hi Guys,
I am trying to use TPT for reading data from oracle to teradata, when i try to choose Job Source it just keeps on spinning but my columns are not getting displayed.
I use TPT 14.10.
Java version i tried with 1.5.0, 1.6.0,1.7.0 and 1.8.0 but same error continues.
Below is the java message from TPT,
java version "1.5.0_22"
|
313 views
|
0 replies
|
Teradata Practice Scenerios
Topic by kumarvaibhav1992
03 Apr 2016
#database #teradata#sql
Hi ,
I want to practice some Query scenerios in teradata,can any one suggest me some blogs or links because i'm not able to find any links with set of good questions.
Cheers!!
|
215 views
|
0 replies
|
How to find number of concurrent users in Teradata
Topic by Mishti
02 May 2012
Hi,
Can anybody please tell me how to find number of concurrent users firing query in teradata at a particular time in PAST.. lets say yesterday.
Can we do this in Pmon ( although we can see all the active users in Pmon, I want to see no. of maximum concurrent users at a specific point of time in past).
Please do reply..Its very urgent!!
|
12511 views
|
8 replies,
4 years ago
|