Administer > Transforming, loading, and extracting data > Overview of the mass load utilities > Resolve identifiers


Create an XML file to use internal-alias ID resolution

When using internal-alias resolution, an alias is substituted in place of the primary key (identifier) in the XML document. This alias is then used elsewhere in the XML file to refer to that element. This eliminates the need to know the unique indexes necessary to build the XML file. Internal aliases must be used consistently throughout the file. If an address-book ID ADDRBOOK_ID is aliased to @addrbook_1, all foreign-key references to that ID in the file must use @addrbook_1. Note that aliases are transient. They are not saved; and they cannot be used in a separate XML file without introducing the aliases again.

Partial example of using internal-alias ID resolution - Before resolution:

 
<MEMBER
    MEMBER_ID="100"
    TYPE="U"
    STATE="1"
  /> 
 
<ADDRBOOK
    ADDRBOOK_ID="@addrbook_1"            Alias for ADDRBOOK
    MEMBER_ID="100"
    DISPLAYNAME="Friends"
    DESCRIPTION="All my friends"
    TYPE="P"
  /> 
 
<ADDRESS
    ADDRESS_ID="@address_1"              Alias for ADDRESS
    ADDRBOOK_ID="@addrbook_1"            Refers to the alias for
ADDRBOOK
    MEMBER_ID="101"
    NICKNAME="Bob"
    ADDRESS1="1 Brave Developer St."
    CITY="Toronto"
    ZIPCODE="A3B0F4"
    COUNTRY="Canada"
    STATUS="P"
  />

After resolution:

 
<MEMBER
    MEMBER_ID="100"
    TYPE="U"
    STATE="1"
  />  
<ADDRBOOK
    ADDRBOOK_ID="11801"                 Generated primary key
    MEMBER_ID="100"
    DISPLAYNAME="Friends"
    DESCRIPTION="All my friends"
    TYPE="P"
  />  
<ADDRESS
    ADDRESS_ID="11901"                  Generated primary key
    ADDRBOOK_ID="11801"                 Refers to ADDRBOOK entry
    MEMBER_ID="100"
    NICKNAME="Bob"
    ADDRESS1="1 Brave Developer St."
    CITY="Toronto"
    ZIPCODE="A3B0F4"
    COUNTRY="Canada"
    STATUS="P"
  />


Related concepts

Overview of the mass load utilities


Related tasks

Configure the idresgen utility

Resolve identifiers

Specify a properties file with the idresgen utility

Create an XML file to use unique-index ID resolution

Related reference

idresgen utility


+

Search Tips   |   Advanced Search