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

checking for activity count for each and every sql in a sql file from a bteq script

I am trying to check the activity count for each and every sql present in a sql file which is run using a bteq script in Unix . Following is the code snippet I am trying to use but the activity count is checked for the last sql but not for all…
venkat
  • 77
  • 3
  • 11
1
vote
1 answer

Timestamp to epoch conversion in teradata

I have a TIMESTAMP column in a teradata table. I want to convert the timestamp to epoch value. Can someone shed some light on how to do this.
user3072054
  • 339
  • 2
  • 6
  • 17
1
vote
0 answers

Socket error - Connection reset by peer

I have a simple housekeeping session that deletes data prior to one month from teradata tables.This is done using SQL transformation.The mapping has logic such that it handles 3 types of files (daily , monthly first week ,monthly -last week).logic…
Shweta
  • 21
  • 2
  • 4
1
vote
0 answers

Error extracting data using TPT script for Fixed width table

I am trying to export data from a fixed width table ( teradata) The following is the error log Found CheckPoint file: /path This is a restart job; it restarts at step MAIN_STEP. Teradata Parallel Transporter DataConnector Version 13.10.00.05 …
K S Nidhin
  • 2,622
  • 2
  • 22
  • 44
1
vote
0 answers

Dealing with duplicate names in Teradata "create table with data"

Is there a way to automate dealing with/ignoring duplicate names when creating a new table in Teradata. Assume I'm joining a table with itself. The table has columns id, email, address1, address2, city, state, zip. , create table mytable2 as ( …
artdv
  • 774
  • 1
  • 8
  • 23
1
vote
2 answers

Teradata partitioned query ... following rows dynamically

I have a table with the following columns and data. Data describes certain customer activity periods cust_id s_date e_date 11111 01.03.2014 31.03.2014 11111 10.04.2014 30.04.2014 11111 01.05.2014 10.05.2014 11111 …
Marko Mahl
  • 13
  • 1
  • 3
1
vote
1 answer

How to create a temp table in teradata

BEGIN; CREATE TEMP FACT TABLE new_table DISTRIBUTE BY hash(a.var3) as SELECT (YEAR(a.var1) - b.var2), a.var3 FROM d.data1 a, c.data2 b WHERE (YEAR(var1) - var2) > 40 ; GO SELECT * FROM age_DRG; END; I am not sure what is wrong with this code. I…
ChrisYee90
  • 389
  • 1
  • 6
  • 12
1
vote
2 answers

Drop rows identified within moving time window

I have a dataset of hospitalisations ('spells') - 1 row per spell. I want to drop any spells recorded within a week after another (there could be multiple) - the rationale being is that they're likely symptomatic of the same underlying cause. Here…
rambles
  • 706
  • 5
  • 9
1
vote
1 answer

Teradata SQL - Adding columns of repeating values to existing table

I have a dataset with 5000 records. I want to add 3 columns to this dataset: 1st one with values from 1 to 5, 2nd with values from 1 to 4, 3rd with values from 1 to 3 such as follows - record_id ser_num5 ser_num4 ser_num3 1 1 …
user3886061
  • 11
  • 2
1
vote
2 answers

Choosing the Most Recent Date

I have three columns (date type) in a table, and I would like to make a fourth column which needs to contain the latest date of the first three columns. Additionally, first three columns can have NULL values. Is there any special function in…
Adam
  • 2,347
  • 12
  • 55
  • 81
1
vote
1 answer

How to call a stored procedure from PyODBC on a Teradata database?

I am running cursor.execute("""{call myStoredProcedure('abc')}""") I get the following error: Error: ('HY000', "[HY000] [Teradata][ODBC Teradata Driver][Teradata Database] 'myStoredProcedure' is not a macro. (-3855) (SQLExecDirectW)") Why is…
web_ninja
  • 2,351
  • 3
  • 22
  • 43
1
vote
1 answer

Fetching data from teradata using teradata bteq utility

I am using Teradata bteq utility to run teradata commands form unix server. I am able to connect to teradata, but while fetching data it gives only 7 columns and a dot(.) at end of decimal field. I am using query, select * from…
user3848027
  • 11
  • 2
1
vote
2 answers

Date conversion in informatica

I am loading date fields from file to teradata table. In a file my date format is mm-dd-yyyy and in my teradata table the format is yyyy/mm/dd. I used the below function for formatting: To_date(to_char(date field,'mm-dd-yyyy'),'yyyy/mm/dd') But all…
Rekha Goverthanam
  • 43
  • 2
  • 6
1
vote
1 answer

Record count increases in PreSQL-Informatica in the absence of Semicolon (;), Database

My PreSQL query in the WorkFlow of Informatica has 2 parts: Insert query Refresh Stats procedure call When no semicolon ; is present between these 2 parts, the record count is given in Millions. When a semicolon ';' is present the record count is…
user3811753
  • 11
  • 1
1
vote
3 answers

Teradata SQL parameter syntax

Is there syntax which allows a parameter marker in the middle of a table name? For example, consider the queries sel * from t?x and sel * from t?x_blah. Both execute as sel * from t1 if the user inputs 1. In the first query x = 1 and…
XXP
  • 23
  • 1
  • 6
1 2 3
…
99
100