Redshift ORDER BY
In this post I have shared how you can use Redshift ORDER BY clause to sort the output rows in the result set. You can… Read More »Redshift ORDER BY
Redshift ALIAS – Column & Table
In this post, we will see how you can use column and table aliases to make sql query more readable and easier for developer too… Read More »Redshift ALIAS – Column & Table
Redshift Select
In this post, I will show you how you can use SELECT statements in Redshift to query data from tables. The SELECT is one of… Read More »Redshift Select
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
DataWarehouse Migration Projects – Beginner Guide
For the past few years I have been involved in many projects where the requirement was to migrate the existing on-premises data warehouse to modern… Read More »DataWarehouse Migration Projects – Beginner Guide
Should you use PARQUET files with Redshift Copy ?
Amazon Redshift supports loading columnar file formats like PARQUET, ORC. This extends compatibility and possibility of moving data easily from different environments for your data… Read More »Should you use PARQUET files with Redshift Copy ?
4 ways to Create Table in Redshift
In the previous post, we saw that you can create table in redshift by specifying 3 minimum details : Table Name, Column Name & Column… Read More »4 ways to Create Table in Redshift
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 occurrs when you try to load or compute numeric value… Read More »Teradata Numeric overflow occurred during computation
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,… Read More »50 Teradata Interview Questions & Answers
