Teradata

Articles

Teradata: FIRST_VALUE and LAST_VALUE Funtions

2021-08-13

Teradata: PIVOT and UNPIVOT Clause

2021-08-13

Calculate Teradata Database Size

2021-04-01

Save Spark DataFrame to Teradata and Resolve Common Errors

2021-03-08

Check User Access on Teradata

2021-01-19

Check Role Access on Tables/Views in Teradata

2021-01-19

Teradata tdwallet Examples

2020-12-27

Teradata No More Room in Database Error and Table Skewness

2020-12-26

Teradata Hash Functions

2020-12-26

Teradata - Update with Joins to Another Table

2020-12-13

Calculate MD5 in Teradata

2020-09-21

Create Procedure with Dynamic Return Result in Teradata

2020-09-21

Convert TimeStamp to Date in Teradata

2020-09-21

Teradata RANDOM Number

2020-09-20

Create Multiset Temporary Table in Teradata

This article demonstrates how to create volatile table in a Teradata procedure, perform DML actions (INSERT, DELETE, UPDATE) against it and then return the result set dynamically from the temporary table in the procedure.

2020-09-20

Load JSON File into Teradata via BTEQ

2020-09-14

Load XML File into Teradata via BTEQ

2020-09-14

Export CSV File via TPT

2020-09-14

Export Text File via Teradata FastExport

2020-09-14

Teradata FastLoad with Optional Quotes

2020-09-13

Teradata FastLoad Skip Header Line

2020-09-13

Teradata FastLoad - Load CSV File

2020-09-13

Load CSV into Teradata via TPT

2020-09-13

Teradata ISNULL Alternatives

2020-09-08

Teradata RPAD - Right Padding

2020-09-07

Teradata LPAD - Left Padding

2020-09-07

Extract XML Data via SQL Functions in Teradata

2020-08-31

Extract JSON Data via SQL Functions in Teradata

2020-08-31

Select First Row in Each GROUP BY Group in Teradata

2020-08-26

Teradata SQL - WITH - Use a reference of a CTE to another CTE

2020-03-15

Useful DBC (Data Base Computer) System Views in Teradata

2018-05-19

Connect to Teradata database through Python

2018-01-10

Setup Teradata in Microsoft Azure

This page provides the steps to create a Teradata database in Microsoft cloud computing platform Azure.

2017-10-15

Teradata SQL Tricks for SQL Server/Oracle Developers

For many SQL Server or Oracle developers, you may encounter some inconveniences when writing SQL queries. For example, how to select from dummy table or local defined variables. This page summarize the equivalents in Teradata SQL.

2017-10-15

Teradata Tutorial – DateTime Related Functions and Examples

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

2017-10-14

[C#] Connect to Teradata Database via .NET Data Provider

2015-05-28

Create ETL Project with Teradata through SSIS

2015-05-16

Connect to Teradata Virtual Machine Guest from Windows Host

2015-05-16

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

2015-05-04

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

2015-05-03

Querying Teradata and SQL Server - Tutorial 0: Preparation

2015-05-02

Install Teradata Express 15.0.0.8 by Using VMware Player 6.0 in Windows

2014-06-29