DSXchange

Hi,

Is their way to do lookup with partial string match?

Like I am looking for a presence of one word in a primary link rather than exact field match and consider it to be matched.

Thanks

Not easy. You could try a sparse lookup with custom SQL using LIKE operator.

I can confirm sparse lookup using LIKE condition does work with the DB2 Connector stage. Oracle also supports sparse lookups. It would be nice if you could do a wildcard match in the Lookup stage no matter what stage was on the reference link. As far as I know you can do exact matches, caseless matches, or range lookups, but not exactly wildcards...

BuddingDev wrote:Like I am looking for a presence of one word in a primary link rather than exact field match and consider it to be matched.

You can, by this method. Suppose your one word is 'dummy'. Search both input and look up key column for this word & if found, populate a new column with value 'dummy'. For other records, populate this new column with original key value. Now do a look up using this new column as key and you can get that you need.

It's friday, so take it easy

In fact, you can parameterize your word as well so that you don't have to edit your job when that word changes.

What makes you think there is only "one word" involved here?

Kandy, are you suggesting using Index() and perhaps making 2 passes through the data? Sounds like that may work to match a partial string and it would simply add extra processing time. I'll have to try it "in my free time." I may have to start my own topic on that later, because I need to do wildcard lookups in real-time web service jobs with NO database I/O (i.e. no sparse lookups).

Your best case is to write a custom operator to do this work. It may be possible to do wildcard lookups through a series of passes through the data -- but this will never be as effecient as a custom op to get the work done in real time or batch for that matter.

Thanks for the tip, Keith. Goal will be to reach millisecond response time! Will have to test that!!

Thank you all for your understandable or not quite understandable responses. :D

I appreciate your inputs but this issue's requirement has changed so I am good for now.