Handling null values in the dimensional modeling.

We usually heard the term 'null' when we work with data so what does it mean?

It looks similar to blank or 0 but actually, it is not. Null is a reserved keyword in SQL to represent missing values in the database. Operations on the missing values will always be missing values and 'null' cant be equal to 'null'. e.g SELECT null = null result will be unknown for this query as the…