QUALIFY in sql applies filter on the output of WINDOW function used in the sql. If in the SQL query you are using window function then you can apply filter on it using QUALIFY. QUALIFY clause is generally the last […]
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 […]
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, 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 […]
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 […]
