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
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 ?
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
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
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… Read More »Teradata Numeric overflow occurred during computation
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