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