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
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
Redshift ORDER BY
Redshift ORDER BY is used to sort the output rows in the result set. You can sort the output rows in ascending or descending order.… Read More »Redshift ORDER BY
Redshift ALIAS – Column & Table
In SQL, ALIAS means another name given to objects like columns & tables. You can use column and table aliases to make sql query more… 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. SELECT is used to fetch… 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
