Stack Overflow
Stack Overflow

Questions tagged [teradata]

Teradata is a Relational Database Management System (RDBMS), capable of supporting many concurrent users from various client platforms. Teradata is compatible with the ANSI standard and built completely on parallel architecture.

The Teradata RDBMS is linearly and predictably scalable in all dimensions of a database system workload (data volume, breadth, number of users, complexity of queries). The scalability explains its popularity for enterprise data warehousing applications.

Features

  • Acts as a "database server" to client applications throughout the enterprise
  • Uses parallelism to manage "terabytes" of data
  • Capable of supporting many concurrent users from various client platforms (over TCP/IP or IBM channel connections).

Utilities

  • Batch Teradata Query (BTEQ) - query tool to load data and export data off at a time
  • FastExport - to exports data from Teradata to a Flat file
  • FastLoad - loads huge amount of data from flat file into EMPTY tables
  • MultiLoad - to load multiple tables at one time from either a LAN or Channel environment
  • Teradata Parallel Data Pump (TPump) - loads data using multiple SQL sessions, using row hash locks
  • Teradata Parallel Transporter (TPT) - combination of BTEQ, FastLoad, MultiLoad, Tpump, and FastExport utilities

Teradata Links

###Related tags :

5537 questions
1
vote
1 answer

Java using teradata giving exception - Only an ET or null statement is legal after a DDL Statement

As per my requirement, I need to pull records from Teradata db. While trying to pull data, I am getting exception as follows. com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.10.00.09] [Error 3932] [SQLState 25000] Only…
Swamy
  • 111
  • 1
  • 2
  • 15
1
vote
3 answers

nth result in Teradata result

I'm trying to make a Teradata SQL query that will return the n-th chronological visit date for each user. E.g., user | visit_date --------------------- a 1/1 b 1/10 c 1/20 a 1/3 a 1/4 b 1/5 c …
Chris
  • 1,421
  • 3
  • 18
  • 31
1
vote
1 answer

Sybase binary conversion to Teradata

I have a SQL query below select convert(binary(20),convert(char(20),'-')) The output is: 2D20202020202020202020202020202020202020 Would like to ask the Teradata equivalent of it. below is my query TO_BYTES(CAST ( LPAD('-', 20, '-') AS VARCHAR(20))…
Gemudesu
  • 59
  • 1
  • 10
1
vote
1 answer

Use Fixed-Width Font in Teradata SQL Assistant Query Window?

Really simple ask: Teradata SQL Assistant's default font for code is variable-width. This is frustrating for formatting and readability reasons, among others. Is it possible to change the font to Courier New or something similar in the Query window?…
SQL Tactics
  • 296
  • 4
  • 15
1
vote
1 answer

PHP ODBC execute is trying to open a file

For some reason this code is causing odbc_execute(); to attempt to open a file... $file = fopen('somefile.csv', 'r'); fgetcsv($file); // Skip the first line $data = []; while (($line = fgetcsv($file)) != false) { $data[] =…
ChristopherStrydom
  • 7,338
  • 5
  • 21
  • 34
1
vote
1 answer

Teradata Window/Rolling Sum under Multiple Conditions

I'm working in Teradata SQL Assistant 14.10 and running into issues with the following problem: I have a list of calculated elapsed times, and I need to create a column that flags when a) the row for which the sum of the elapsed time exceeds 20 min…
apd2zn
  • 33
  • 4
1
vote
1 answer

How to tokenize a string and assign tokens to column in Teradata?

I have multiple strings of the form {key1=value, key2=value2, key3=value3 ...} with a known set of keys. The key names are set and known, with only the values changing between records. I would like to tokenize the string with the space delimiter as…
sakurashinken
  • 3,940
  • 8
  • 34
  • 67
1
vote
2 answers

Implement qualify row_number

How to implement qualify row_number over(Partition by col order by col) and char2hexint() functions**(these are teradata functions)** in informatica in a way for which push down optimization(pdo) query is available? Apart from sql overriding or…
mac07
  • 51
  • 8
1
vote
3 answers

How to TRANSLATE unicode to latin in Teradata?

My table contains a field lastName that is UNICODE I need to implement the SOUNDEX function, but it won't work because it requires only latin. So I tried converting it to latin but still get the same error only latin letters allowed Here is what i…
Pasha
  • 181
  • 1
  • 1
  • 13
1
vote
2 answers

Teradata SQL: Max (greatest), 2nd and 3rd greatest column names

I have a table with 6 columns in Teradata as follows: ID Feature1 Feature2 Feature3 Feature4 Feature5 1 12 15 1 22 350 2 121 0.9 999 756 879 ... I need to get the column…
julian_b
  • 45
  • 1
  • 8
1
vote
0 answers

How to manage change data capture with Teradata?

I am facing a problem...how to do change data capture with Teradata as a source. I've found several tools but all of them use Teradata only as a target and sources are "traditional" database systems like Oracle, DB2... The closest shot I have is…
Bohuslav Dvorský
  • 89
  • 9
1
vote
1 answer

Translating Unicode to Latin in Teradata

In SQL Server you can convert Unicode character sets into Latin character sets by using CAST(src COLLATE SQL_Latin1_General_CP850_BIN2 AS VARCHAR(255)) However the collate function does not exist in Teradata, I know you can use collation to set the…
Bob
  • 746
  • 3
  • 11
  • 26
1
vote
1 answer

unixODBC connection with Teradata

Has anyone ever got this to work on RHEL? I have successfully installed Teradata 14.10 on my box. BTEQ works fine and I've tested the Teradata odbc connection using tdxodbc, which also successfully works. My problem is I want to connect via Python…
Michelle Walker
  • 21
  • 1
1
vote
0 answers

Squirrel SQL mac lag when typing codes

My screen lags very badly when I type my sql codes in the Squirrel interface. When I scroll up or down the page the interface also lags in and out. It becomes very hard to type code if it is more than 10 lines. I have tried reinstalling Squirrel and…
Cicero
  • 11
  • 1
1
vote
1 answer

linux teradata ODBC SQLConnect Error

I can successfully connect to DB2 using my odbc files. But when I try it with Teradata I get the following error: $ /opt/teradata/client/13.10/odbc_64/samples/C/adhoc /opt/teradata/client/13.10/odbc_64/samples/C/adhoc: /usr/lib64/libodbc.so: no…
Michelle Walker
  • 21
  • 1
1 2 3
…
99 100