You can use various tools and methods to detect and analyze null values, such as SQL queries ... as establishing default values in dimension tables, employing surrogate keys for unknown values ...

Write a SQL statement to create duplicates of countries table named country_new with all structure and data. Write a SQL statement to insert NULL values into region_id column for a row of countries ...