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 … Read More
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 … Read More
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, … Read More
My experience of AWS Certified Solutions Architect – Associate
I recently appeared for AWS Certified Solutions Architect (Associate) exam and cleared it comfortably. I would like to share my experience and journey so far which may help you if … Read More
Redshift Load S3 Data into table
In the previous post, we created few tables in Redshift and in this post we will see how to load data present in S3 into these tables. To load data … Read More
Redshift Create Table Example
In this post, we will see a very simple example in which we will create a Redshift table with basic structure and then we will see what all additional properties … Read More
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 … Read More
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 … Read More
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 … Read More
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 solutions to him however due … Read More