Teradata

Tutorials and information about Teradata.

rss_feed Subscribe RSS

local_offer teradata local_offer teradata-utilities

visibility 25
thumb_up 0
access_time 10 days ago

Teradata Parallel Transporter (TPT) provides rich functions to load data into Teradata and to export data. In article Load CSV into Teradata via TPT , it shows how to load CSV files into Teradata. This page provides examples to export data from Teradata to CSV. Use TPT wizard GUI tool to create a ...

local_offer teradata local_offer teradata-utilities

visibility 12
thumb_up 0
access_time 10 days ago

BTEQ is a Teradata utility tool that can be used to run Teradata SQL statements incl. DDL, DML, etc. It can also be used to import data from text file into Teradata databases. Like TPT and FASTLOAD, it can run in both batch and interactive modes. This article demonstrates how to load XML file into ...

local_offer teradata local_offer teradata-utilities

visibility 11
thumb_up 0
access_time 10 days ago

BTEQ is a Teradata utility tool that can be used to run Teradata SQL statements incl. DDL, DML, etc. It can also be used to import data from text file into Teradata databases. It also works with XML and JSON files too. Like TPT and FASTLOAD, it can run in both batch and interactive modes. This ...

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 12
thumb_up 0
access_time 16 days ago

In SQL Server, ISNULL function is commonly used to populate a value for null columns.  In Teradata, there is no ISNULL function but COALESCE and CASE WHEN can be used as alternatives.  SELECT COALESCE(NULL,'ABC','CDE'); Result: ABC SELECT COALESCE(Col1, Col2,'DEFAULT') FROM ...

local_offer teradata local_offer teradata-functions

visibility 9458
thumb_up 0
access_time 3 years ago

This post summarize the common functions that are used when dealing with DateTime datatypes in Teradata.

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 10
thumb_up 0
access_time 17 days ago

Teradata RPAD function is used to add repeated characters at the end of a string to increase the string to a specified length. It can be used to add trailing space or zeros to a string. RPAD(source_string, length, fill_string) Returns the source_string padded to the right with the characters in ...

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 10
thumb_up 0
access_time 17 days ago

Teradata LPAD function is used to add repeated characters at the beginning of a string to increase the string to a specified length. It can be used to add leading space or zeros to a string. LPAD(source_string, length, fill_string) Returns the source_string padded to the left with the ...

local_offer teradata local_offer SQL local_offer teradata-sql-query

visibility 22
thumb_up 0
access_time 24 days ago

XML data type is commonly supported in Teradata. Together with native XML type, a number of XML functions are added to support extracting values from XML, shredding and publishing JSON, etc.  info The following code snippets use string literal to demonstrate the usage of these functions; you ...

local_offer teradata local_offer SQL local_offer teradata-sql-query

visibility 21
thumb_up 0
access_time 24 days ago

JSON data type is supported in Teradata from version 15.10. Together with native JSON type, a number of JSON functions are added to support extracting values from JSON, shredding JSON, etc.  info The following code snippets use string literal to demonstrate the usage of these functions; you ...

local_offer teradata local_offer SQL local_offer teradata-sql-query

visibility 30
thumb_up 0
access_time 29 days ago

As other databases, Teradata provides many aggregation functions that can be used to retrieve SUM, COUNT, MAX, MIN and AVG values. These functions returns a single value per group. To retrieve the whole first row from each 'GROUP BY' group, windowing functions can be used.  The following code ...