CAST function in Teradata
CAST function converts one datatype to another datatype in teradata. The value must be compatible with new datatype else it will result in error. CAST… Read More »CAST function in Teradata
Teradata SQL
Teradata SQL related posts in this category
Sysdate in Teradata
There is no sysdate built-in function in Teradata. You can use current_date and current_timestamp function.You can also create custom function named "sysdate" to replicate it… Read More »Sysdate in Teradata
Teradata Date Functions – Syntax and Examples
Teradata Date Functions Date consists of 3 parts – Day , Month & Year. When we combine all 3 parts together we get the output… Read More »Teradata Date Functions – Syntax and Examples
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… Read More »Teradata concatenate – syntax and example
Teradata Numeric overflow occurred during computation
Numeric overflow in Teradata occurs while handling numeric values in computation or transformation. Numeric overflow occurs when you try to load or compute numeric value… Read More »Teradata Numeric overflow occurred during computation
50 Teradata Interview Questions & Answers
50 Teradata interview questions to gain some confidence before your first round of interview. I am sharing below 50 Teradata Interview questions which covers various… Read More »50 Teradata Interview Questions & Answers
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… Read More »Moving from Teradata to Hadoop – Read this before
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… Read More »Convert number to TIME in Teradata
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.… Read More »Teradata TPT Export script
Fetch Metadata of View in Teradata via HELP
Recently someone in my team asked me how to fetch column list along with datatype from VIEW definition via jdbc connection. I proposed couple of… Read More »Fetch Metadata of View in Teradata via HELP
