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

is concat() worsening the performance of my sql queries?

I have dozens of tables, that I have to join constantly using three string fields. f1, f2 and f3 are always not null and each of them have a fixed number of characters. I know that that's not very optimal but I can only query the database, I am not…
user4126054
1
vote
1 answer

Teradata Fastload date format issue

I have a flat file which I am trying to load through fastload. The flat file has date in the format dd/mm/yyyy. When I am trying to load it through fastload the records are going in the Error tables. However, when I change the format of date in the…
user3901666
  • 399
  • 11
  • 29
1
vote
1 answer

How to create dynamic dummy variables in SQL

I have a simple table with 2 columns: ID (integer) and Category (string), and each ID can repeat with a few categories, like so: ID Cat --- --- 1 A 1 B 2 B 3 A 3 B 3 C I want to reshape this table so that each unique…
Giora Simchoni
  • 3,487
  • 3
  • 34
  • 72
1
vote
2 answers

Parameters and teradata Dynamic SQL

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…
Charles Ayotte
  • 11
  • 1
  • 3
1
vote
0 answers

Teradata high volume table optimization

I have to optimize this table structure. This table has 43 million records and it will grow. Any suggestions on creating the PPI n all. This table along with 5 similar tables are being used in a Business view. CREATE MULTISET TABLE…
user3901666
  • 399
  • 11
  • 29
1
vote
0 answers

reference index subtable distribution

I am aware of the fact that maintaining the reference index subtable has similar overhead to USI subtable. What I am trying to understand is that what kind distribution would it have. My guess is that it will be on basis of the PRIMARY KEY of the…
user3055262
  • 405
  • 3
  • 9
  • 20
1
vote
1 answer

Explain plan for update operation involving join index

Below is the explain plan I can't wrap my mind around. On a high level it seems it is updating the Lineitem table through the OrderLine join index (not at all sure about this), and it is executing this in parallel, Explanation 1) First, we execute…
user3055262
  • 405
  • 3
  • 9
  • 20
1
vote
1 answer

How to create a new column from existing column?

In a table AZ I have 3 columns say a,b,c || here c is alias of d || how to create a new column in same table say "e" from column c select a.lyl_id_no, sum(a.trn_tot_prc) as PURCH, sum(case when a.trn_dt > current_date - 365 then 1 else…
user3865742
  • 13
  • 4
1
vote
1 answer

In Teradata how do I script out all stored procedures and tables?

I am working on documenting an existing set of databases in a Teradata installation. I am from a SQL Server background. How do I script out all stored procedures and tables in a Teradata DB, like I would in SQL Server, by using the Generate Scripts…
JoeK
  • 88
  • 3
  • 10
1
vote
1 answer

Date in varchar and dd-mmm-yy format

I am stuck in this query. The below part "TRANSMITTED_DATE LIKE '17-JUL-14'" is hardcoded. I want to make it a generalized one. I want to do something like this WHERE CAST(TRANSMITTED_DATE AS DATE FORMAT 'DD-MMM-YY') BETWEEN …
user3901666
  • 399
  • 11
  • 29
1
vote
1 answer

Import file to table error : Failure 2673

I'm trying to load an csv file (delimited by |) to a Teradata table using BTEQ. Unfortunately I'm getting the error Failure 2673 The source parcel length does not match data that was defined. Any thoughts on what could be the cause of these error is…
mysticfalls
  • 445
  • 5
  • 17
  • 28
1
vote
1 answer

join index or collect stats which is better in Teradata

Am facing an issue with one of my FACT tables. Through same job, I call a procedure to load this FACT table and then second procedure to collect stats on this fact table. As part of a new requirement I need to create a join index which will also…
anoop john
  • 211
  • 1
  • 5
  • 6
1
vote
1 answer

Fastload to temporal table

Had a cvs file containing 3 fields 1,cat,2012-06-16,2013-06-16 1,cat,2013-06-16, I am trying to load that to temporal table having valid_dt PERIOD(DATE) using fastload script nonsequenced validtime INSERT INTO financial.test1…
user2711819
  • 960
  • 3
  • 16
  • 29
1
vote
1 answer

User-Defined variable in query teradata

I want to run a similar query at different times changing only one thing in the where clause and the table name that it's pulling from. declare ?tablename varchar(100); set ?tablename = 'some_table_this_time'; declare ?id int; set ?id = 12 select…
skmathur
  • 1,587
  • 5
  • 14
  • 21
1
vote
1 answer

Get Firstname and lastname from String in Teradata

In Teradata how to get Firstname and lastname from a string example:Samaira Oberoi the function should return firstname as : Samaira Last name as :Oberoi also if there is no space it should return the whole set Thanks
user3438498
  • 211
  • 3
  • 11
  • 21
1 2 3
…
99
100