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
2 answers

how to handle nulls in date coulmn in teradata

This is my sql and i want to handle nulls for date coulmn . sql: insert into r_intraday_netrev ( report_time, snapshot_time, prodtype, qty, yestasp, m2_cumpct, m2_predictedunits, m2_rev, m3_cumpct, m3_predictedunits, m3_rev) select…
Srinivas P
  • 31
  • 3
  • 9
1
vote
1 answer

Teradata SQL: Compare values inside group

I've run into a problem recently and cannot seem to find a nice solution to it using SQL (or otherwise). I have a table like below uid | event | start_date | end_date 1 A 23/07/2014 NULL 1 B 25/07/2014 NULL 1 C …
Black
  • 4,483
  • 8
  • 38
  • 55
1
vote
1 answer

Unknown error occurred in terasso library, unable to connect to teradata using vba

I have really simple code. Last line return such error, I use not english version, so it might look a bit different: "the data source is not found and a default driver is not specified". Private objConn As New ADODB.Connection …
Rocketq
  • 5,423
  • 23
  • 75
  • 126
1
vote
1 answer

how to update rows by a range of dates in teradata

I have two tables in a teradata database that look like this accounts account_number integer date_updated_last datetime delinquency_code varchar(3) payments account_number integer statement_date datetime delinquency_code varchar(3) the delinquency…
Chris Drappier
  • 5,280
  • 10
  • 40
  • 64
1
vote
1 answer

Call SSIS package from a stored procedure

How can we call an SSIS package from a stored procedure and pass it a parameter?
Punit Kishore
  • 41
  • 4
1
vote
1 answer

Group By Nullable Column In Teradata

What happens when I group by a column in Teradata which is nullable ? Are those records which have the corresponding field's value AS NULL get eliminated ? Please Explain with an example !
StrugglingCoder
  • 4,781
  • 16
  • 69
  • 103
1
vote
1 answer

Use Stored Procedure OUT Parameter in Unix Script

I have a ksh script that is directly Selecting a count from the database. I am replacing this with a call with a stored procedure. My Stored Procedure selects into an OUT variable. How do I capture the OUT value into my data file as declared in my…
staples
  • 424
  • 2
  • 8
  • 24
1
vote
1 answer

Session error in Teradata Fastload Script

My Fastload script is scheduled to run every week and when it starts the script failed because of the insufficient number of sessions every week. but, when I restart the script manually then it executed with no session error. I don't what causes it…
Rahul Mittal
  • 99
  • 8
1
vote
2 answers

Fastload Error with Decimal: 2679

I'm trying to fastload some data. The second column should be treated as a decimal, however I keep getting 2679 bad character errors when I try to load the data. Any suggestions as to what is going…
cloud36
  • 1,026
  • 6
  • 21
  • 35
1
vote
1 answer

Sqoop Incremental Import and CURRENT_TIMESTAMP

I am trying incremental import through SQOOP from Teradata to Hadoop. which is not working in my case. It seems from error that SQOOP internally creating SQL which are syntactically incorrect. I even tried with --verbose option ....no usefull…
Sanjiv
  • 1,795
  • 1
  • 29
  • 45
1
vote
1 answer

TERADATA - How to split a character column and keep the last token?

I have a table with article names and I would like to select the last word of each article of the table. Right now I'm doing it in SAS and I my code looks like: PROC SQL; CREATE TABLE last_word as SELECT scan(names,-1) as last_w FROM…
Martí Mayo
  • 31
  • 5
1
vote
1 answer

Can't set column name equal to variable which is determined by the user

I am creating a result set where I want the column name to be equal to a variable name that is et during run time. Is that possible ? How do I do that? In the example below the user choses the date (myDate) before running the query (e.g 2015-06-11).…
Filip Eriksson
  • 975
  • 7
  • 30
  • 47
1
vote
0 answers

Declaring field to use Unicode UTF-16

I am trying to use the Unicode UTF-16 character set, but I am unsure how to do this, by default when I use the Unicode character set it uses UTF-8 which changes foreign Spanish, Arabic, etc. characters into ?. I am currently using Teradata 14.
Bob
  • 746
  • 3
  • 11
  • 26
1
vote
1 answer

How to show records were 3 fields match

I'm trying to write a query that will list the columns in a table when 3 specific fields are the same, but unknown: TABLE: FIELD 1 | FIELD 2 | FIELD 3 | FIELD 4 ---------|--------------|------------|--------------- 1 | 01-01-15 …
DJDJ23
  • 139
  • 1
  • 2
  • 12
1
vote
1 answer

What is the difference between executing a macro and executing the contained instructions within it in Teradata?

Sometimes it can well be observed that individual instructions within a macro execute way faster than a whole macro in Teradata ? Is this just a delusion or is there any logic behind it ? I am newbie to Teradata and I will appreciate if someone…
StrugglingCoder
  • 4,781
  • 16
  • 69
  • 103
1 2 3
…
99 100