In a Universe database, when I run the following SQL query:
SELECT DISTINCT INV_LOC_A FROM UNNEST INV ON LOCATIONS;
I get 13729 results. However, when I run the Universe query:
SELECT INV SAVING UNIQUE INV_LOC_A
I get 11697 results.
The INV_LOC_A dictionary is a multivalued field, and part of the LOCATIONS association. Why are these two different values, and which number is correct?