User Key Attribute Join Object Type

A user key attribute join is an object that specifies a join operation that EIM can use to convert a user key attribute that is a foreign key to another table into attribute column values in that table.

For example, the S_PROD_INT products table includes the S_PROD_INT_U1 user key. This user key references the following columns:

• PROD_NAME

• PROD_VENDOR

• PROD_VEN_LOC

EIM gets the PROD_NAME column from the S_PROD_INT table. No join is required.

EIM must use a join to get the PROD_VENDOR and PROD_VEN_LOC columns from the S_ORG_EXT accounts table. EIM uses a join on VENDR_OU_ID, which is a foreign key from the S_PROD_INT table to the S_ORG_EXT table.