Identity Assignment during Import
When you import records in TIBCO MDM from external sources, you may need to map new records to the existing records in TIBCO MDM. If the imported data does not have PRODUCTID and PRODUCTIDEXT, it is not possible to detect whether the data being imported is for existing records or new records. In such cases, the identity of the record is established by a set of business keys. If identity is not established correctly, duplicates may be imported.
Consider the following scenario: A person is identified by business keys, such as, first name, last name, SSN, and zip code, and you have imported this data in TIBCO MDM. When the update is available, to associate this data with the existing records, the data must be identified by PRODUCTID and PRODUCTIDEXT. However, the PRODUCTID and PRODUCTIDEXT may not be known to external source and may not be available in the updated data. Therefore, to map this data with the existing records in TIBCO MDM, business keys are used.
You can assign an identity to records that are being imported using the following two ways:
- Adding an <assignidentity> action tag in a rulebase file, and then using the rulebase file in PrepareForImportCatalog activity. For information on how to add <assignidentity> tag in rulebase, refer to Adding Assign Identity in Rulebase.
- Using the
button in Rulebase Designer. For more information, refer to TIBCO MDM Studio Rulebase Designer User’s Guide.