When you create and use transformations, consider these issues:

• Design and create as many attributes and transformations as possible before populating or updating the staged schema.

  After defining any new transformations for any attribute, you must run the DQM Staging program to generate or update the staged schema. Processing the staged schema can require significant computing resources and time. If you are uncertain about initially adding a transformation or an attribute with the initial group of transformations and attributes, the best strategy is to add the transformation.

• Do not transform lookups. Lookups have a predetermined or known set of values, so you cannot transform them.

• Remember that word replacements are called within a transformation.

• Consider the possibility that your party information might contain compound names that were entered with the modifier following a comma.

  For example, The New Datsonville could have been entered into your party information as Datsonville, The New. You can create a transformation that reverses the text before and after the comma in any city name.

• If the Domain attribute has only domain values, use the Core Domain Extraction transformation. If the attribute has e-mail addresses, use either the Core Domain Extraction or Full Domain extraction transformation.

  You can modify or add codes to the:

  • E-Mail Domain Suffixes (HZ_DOMAIN_SUFFIX_LIST) lookup type, which the Core Domain Extraction transformation uses to identify core domains.

  • ISP E-Mail Domains (HZ_DOMAIN_ISP_LIST) lookup type, which both transformations use to remove ISP e-mail domains from the matching process.

  The transformation compares against the code, not lookup meaning or description.

  See: Defining Receivables Lookups.

  Attention: Before you can use new or updated lookups, you must generate or update your staged schema. See: DQM Staging Program.