DSXchange

Hi there,

Multiple look up results means one searching returns more than one results if more than one records meet the search criteria. We all know hash file does not support multiple look up results. I know only ODBC data source supports multiple look up results. Is there any other database source supporting the multiple look up results?

Thanks,

The ODBC and UV stages are the only ones that support that option.

Thanks Craig.

What happens for those do not support returning multiple look up results when a search yields more than one records? Do they just pick up one randomly and return to users?

Thanks,

Depends on the stage writer. Won't be random but it could be the first, could be the last, may log a warning or may not... varies from stage to stage from what I've seen.