Use Target Rules
Refer to Data Services AutoGen for more information.
There are two types of Target rules that can be assigned to Target fields:
Complex rules allow a user to document rules. These rules may not have been written yet, or may have been written and saved in a data source. The documentation associated with a Complex rule can contain the rule type (such as stored procedures, BODS functions, or SQL functions), a rule description, and a rule definition. Refer to Add a Complex Rule for more information.
NOTE:Complex rules are for documentation purposes only and provide information that the Data Services developer uses when writing the rule. When an AutoGen request is processed, a placeholder where Complex rules can be developed is created. Complex rules are not overwritten in Data Services.
Basic rules are logic conditions associated with a Target field that are used in Data Services AutoGen. They can be used to apply conditions based on up to three combined fields. When Data Services AutoGen runs, the Basic rules are added to the job in the enrichment data flow based on the priority set in Target Design. Basic rules are overwritten using the rule definition from Target Design each time Data Services Jobs are automatically generated. Refer to Add a Basic Rule for more information.
NOTE: If a rule is set in Target Design, that rule is owned by Target Design. When the rule is pushed to Map, a note attached to the mapping record indicates that the rule has already been set in Target Design and cannot be updated in Map.