Extract, Transform, Load with SQL on Teradata & Amazon Redshift
Teradata COALESCE function is used for NULL Handling. It returns the first not null value which is passed to it. If all the values passed to COALESCE function are NULL then output would be NULL else output would be first NOT NULL value encountered. Teradata Coalesce Date You can use coalesce to convert NULL values … Read more
In Teradata, there are various date formats & date functions available and I have seen so many people getting confused and committing mistakes while handling columns & values of DATE datatype. Also fixing date related errors sometime is not a straightforward tasks. In this post, we will see different date functions we can use to retrieve required … Read more
In this post, I have explained what are Slowly Changing Dimensions (SCD) and how you can implement it in your projects in the efficient manner. What is Slowly Changing Dimension ? A Dimension table stores attributes and descriptive details about the measures calculated in the Fact tables. With time it is expected that some changes … Read more
In this post I will share a quick method which you can use to create a data model from any existing SQLs in your data warehouse environment. Data Model actually plays a very vital role in building understanding of your data warehouse. When you are new to any project, understanding the existing data model can … Read more
In this post, we will see how you can create Redshift Stored Procedure with example. We will also talk about redshift stored procedure parameters and dynamic sql in stored procedure. What is a stored procedure ? Stored Procedure (SP) is a database object which encapsulates business transformation logic into one unit. Stored Procedure can consists … Read more
