Does it make sense to load the vocabulary tables with _CONCEPT_ID columns with NULL values as long as it is not required?
When we are loading DRUG_STRENGTH table into our local database, we specify NULL values for all empty strings irrespective of column. So, we get NULL values in NUMERATOR_UNIT_CONCEPT_ID which is not required but when we ran DQ check we get Conformance fail because there are close to 50% NULL values for NUMERATOR_UNIT_CONCEPT_ID column. The result can be seen below
Now the question becomes, should we load the columns with _CONCEPT_ID in the vocabulary tables with empty strings as 0 instead of NULL?