What Data Sources Support Multiple Look Up Results?

olgc · Post by **olgc** » Thu Jan 08, 2009 8:37 am

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,

chulett · Post by **chulett** » Thu Jan 08, 2009 8:45 am

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

olgc · Post by **olgc** » Fri Jan 09, 2009 9:51 am

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,

chulett · Post by **chulett** » Fri Jan 09, 2009 10:09 am

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.