Top "Teradata" questions

Teradata is a Relational Database Management System (RDBMS), capable of supporting many concurrent users from various client platforms.

Best way to compare contents of two tables in Teradata?

When you need to compare two tables to see what the differences are, are there any tools or shortcuts you …

sql teradata data-comparison
COALESCE vs IS NOT NULL performance on checking empty string

Some articles I found on the internet compared ISNULL with COALESCE, so I think my question is a little different. …

sql teradata
Left join without multiple rows from right table

I have two tables (User and Salary). I want to do a left join from User to Salary. For each …

sql sql-server teradata
Difference between "TOP" and "SAMPLE" in TeraData SQL

What is the difference between "TOP" and "SAMPLE" in TeraData SQL? Are they the same?

sql teradata
SQL Concatenate multiple rows

I'm using Teradata, I have a table like this ID String 123 Jim 123 John 123 Jane 321 Jill 321 Janine 321 Johan I want to …

teradata concat partition
teradata sql pivot multiple occurrences into additional columns

I have something like this: ID Result 1 value1 2 value1 2 value2 3 value1 4 value1 4 value2 4 value3 And I'd like to return something …

sql pivot teradata
Error: String contains an untranslatable character - TERADATA (for REGEXP_REPLACE operation)

I need to clean one character column and for that I am using REGEXP_REPLACE function in Teradata 14. The same …

sql teradata regexp-replace
Move data from oracle to HDFS, process and move to Teradata from HDFS

My requirement is to Move data from Oracle to HDFS Process the data on HDFS Move processed data to Teradata. …

oracle hadoop teradata apache-storm
Connecting to Teradata using Python

I am trying to connect to teradata server and load a dataframe into a table using python. Here is my …

python teradata pandas-to-sql
How to extract Stored Procedure body in Teradata

I'm trying to extract Stored procedure DDL by querying system tables. If I run the following query select * from dbc.…

procedure ddl teradata system-tables