What could be reasons that codes appear under the ‘Unmapped’ category for a SQL-generated dimension structure? Note: There are 3 correct answers to this question.

What could be reasons that codes appear under the ‘Unmapped’ category for a SQL-generated dimension structure? Note: There are 3 correct answers to this question.
A . The SQL statement returns the external code and employee data uses the external code.
B. The SQL statement returns the internal code and employee data uses the external code.
C. The SQL statement returns the external code and employee data uses the internal code.
D. Leaf node descriptions generated via SQL do NOT match the values returned in the data.
E. Leaf node IDs generated via SQL do NOT match the values returned in the data.

Answer: B,C,E