teradata

Articles tagged with teradata.

local_offer teradata local_offer fastload local_offer teradata-utilities

visibility 12
thumb_up 0
access_time 11 days ago

Teradata FastLoad can be used to load CSV/TSV or other delimited files into database. Refer to article  Teradata FastLoad - Load CSV File  for more details about how to load CSV into Teradata. This article shows how to skip header line or multiple lines in the input file.  Create a ...

local_offer teradata local_offer fastload local_offer teradata-utilities

visibility 19
thumb_up 0
access_time 11 days ago

Teradata FastLoad is a command line utility that can be used to load large amount of data into an empty table on Teradata database. The performance will be greater than line by line or batch processing mechanism. This article provides example of using FastLoad to load CSV file into Teradata ...

local_offer teradata local_offer teradata-utilities

visibility 23
thumb_up 0
access_time 11 days ago

TPT (Teradata Parallel Transporter) is a client suit that support multiple instances of data extracting, loading, and updating functions in a scalable, high-speed, parallel-processing environment. It utilize other client tools like FastLoad, FastExport, MultiLoad, etc.  It is written with Java ...

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 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 24
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 ...

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 24
thumb_up 0
access_time 3 months ago

The following code snippets show how to use round numbers to hundreds or thousands in Teradata.  warning Alert - The following code snippets are used to round to the smallest hundreds or thousands that is equal or greater than the input number.  FLOOR and CEILING fun ctions In ...

Read more

Find more tags on tag cloud.

launch Tag cloud