Please choose one of the following. In a static, non-multi-row lookup,
A) lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced
B) If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced
C) If the lookup finds two records that match the search key, it will return two records
D) None of the above

Question

Quizplus · Accepted Answer

In a static, non-multi-row lookup, if a lookup search does not find a value, the original row is typically retained with nulls for the lookup fields, and if multiple matches are found, it usually results in an error or undefined behavior, not returning multiple records.

Please Choose One of the Following