Use Where Exists Enable to use WHERE EXISTS type SQL statements instead of LEFT JOIN type statements for lookups in ELT processing. Notes: This setting is part of the Data Vault settings category. The default value for this setting is N.