Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-07-14T18:22:03Z by RobertDickson
SystemAdmin
SystemAdmin
533 Posts
ACCEPTED ANSWER

Pinned topic QS Job with Reference Match and IST I/O stages: Issues and Questions

‏2013-02-12T22:06:48Z |
Hi Everyone

I am trying to design a quality stage job which will take
1. A single record Input as simple as the First Name, Middle Name and Last Name columns
2. Should be able to fetch the exact/duplicate matches from a DB table with the above columns based on NAME_UNCERT algorithm in Reference Match Stage.
3. This should be deployed as a web service with ISD Input and ISD output.

In cases like above scenario, I came to know that Look up stage must be used(http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.infoservdir.user.doc%2Ftopics%2Ft_create_realtime_ref_match.html).

Here I have the following questions.

1. To use a look up stage I need to use a join column. Look up stage in my case is totally unnecessary. I don't have join key column to link in DB. I need to use ALL the records from reference DB for the Reference Match stage.
2. Assume that there are a million records in database. Can I use Look up stage to feed in all the million records to Reference Match Stage.
3. Just wondering why is this look up stage made mandatory here. In my scenario or any other scenario do we really need it ?
  • RobertDickson
    RobertDickson
    41 Posts
    ACCEPTED ANSWER

    Re: QS Job with Reference Match and IST I/O stages: Issues and Questions

    ‏2013-07-14T18:22:03Z  in response to SystemAdmin

    Hi,

    A lookup stage OR a Join (Use the OBDC stagewith the SPARSE option set) will work.  Your key would be all records that meet your blocking strategy.  For example, if you have one pass that is blocking on NYSIIS of last name and First Character of Match First Name, then those two columns would be your key.

    Good luck!

    Robert