An Identity Link Table (IDL) is an SQL accessible table that contains information about the relationship (links) between rows of an IDT. A link has directionality. That is, a parent row is linked to a child row. The strength of the link is defined by a score (0 to 100).

Links are established by a search and matching process. A

Multi-Search-Definition

is used to define the

For example,

Link-PK

adds the PK field values from the parent and child records to the Link Table. Refer to section

Layout

for details.

Link-Hard-Limit

prevents adding rejected candidates to the Link Table. The default is to add all candidates to the table.

Link-Self

adds links for rows that can find themselves. By default, links are not stored for these rows.

A standard Link Table contains the following columns:

Column Name	Meaning
RECID	A unique record ID for this Link Record
IDS_PARENT	The RECID of the parent IDT row
IDS_CHILD	The RECID of the child IDT row
IDS_SCORE	Result of scoring parent with child (0-100)

The default table only stores the RECIDs of IDT rows because they are guaranteed to be unique.

The Multi-Search Option

Link-PK

instructs IIR to inject the PK columns of the parent and child rows into the IDL as well. The parent and child column names are prefixed by

IDS_P_

and

IDS_C_

respectively.

A Link Table is created from the Console with

Tools

Link Table

, or by running

relate

with the

-xl

switch.

Multiple-threads are supported, so you can create the IDL with

-n3

for example. The Synchronizer does not maintain the relationships in Link Tables.