The DW extracts often include a substantial number of records that should have specifically been excluded by the segment applied in the extract.
For example, segment container is Hit, and the condition is that eVarX does not equal "Unspecified" (we have also tried it with the condition eVarX exists - same result). And yet, the extract contains tens of thousands or records where eVarX is blank. Checking these records in Workspace produces "Unspecified" as the value for eVarX .
The impact is that the extracts are oftentimes bloated x10, they take longer, and require additional cleansing. Any suggestions on how to prevent the extracts from picking up these records?
Thank you