Teradata concatenate – syntax and example
In Teradata, we can use concatenation operator to link multiple string or numeric or expression values into single value. Input for concatenate can be two or more but output of concat is always one....
Category: Teradata SQL
Teradata SQL related posts in this category
Teradata Numeric overflow occurred during computation
Numeric overflow is a very common error in Teradata which you will encounter while handling numeric values in computation or transformation. The error comes when you try to load or compute numeric value which...
50 Teradata Interview Questions & Answers
I am sharing below 50 Teradata Interview questions which covers various topics and shall help in preliminary rounds of Interview. It covers basic architecture questions, utilities related – Fastload, Multiload, BTEQ questions, SQL questions,...
Moving from Teradata to Hadoop – Read this before
It’s been few years since I have been working on HIVE, Impala, Spark SQL, PySpark, Redshift and in the journey so far I have migrated many applications in different RDBMS like Teradata, Netezza, Oracle...
Convert number to TIME in Teradata
While calculating measures you may want to convert seconds to TIME. Say you want to know how many HOURS,MINUTES & Seconds constitute this number. Example you may want to convert 500 seconds to hh:mi:ss...
Teradata TPT Export script
If writing a typical TPT script is tedious task for you then you may try using existing TPT templates to quickly write a TPT script. Teradata provides list of templates for all the TPT...