Table of Contents

Search

  1. Preface
  2. Workflows
  3. Workflow Variables
  4. Workflow Parameters
  5. Cluster Tasks
  6. Command Task
  7. Human Task
  8. Mapping Task
  9. Notification Task
  10. Gateways
  11. Workflow Recovery
  12. Workflow Administration

Developer Workflow Guide

Developer Workflow Guide

Rules and Guidelines for Task Distribution By Column Values

Rules and Guidelines for Task Distribution By Column Values

Consider the following rules and guidelines when you specify data values and user or group names for task distribution:
  • You can enter the data values and the user or group names in a grid in the
    Task Distributio
    n tab. Or, you can import the data values and the user or group names from a table or a file.
  • Enter each combination of data values and user or group names on a single row.
  • To associate a value with a user or group, enter a single value in the first column and a single user or group in the second column.
    To associate a range of numbers with a user or group, enter the lower value in the first column and the upper value in the second column. Then, enter the user or group name in the third column.
    To associate a range of dates with a user or group, enter the earlier date in the first column and the later date in the second column. Then, enter the user or group name in the third column.
  • You can select a table that contains more than three columns. The task configuration uses the first two columns if you specify single data values or the first three columns if you specify ranges of values. The task configuration disregards additional columns.
  • The lower and upper values correspond to the Start and End values in the
    Task Distribution
    tab. The earlier and later dates correspond to the Start and End dates.
  • On each row, the Start value must be lower than or equal to the End value. The Start date must be lower than or equal to the End date.
  • The workflow treats each range as inclusive. For example, a range of 50 through 99 includes the values 50 and 99. The ranges that you set cannot overlap.
  • The users and groups that you specify must exist in the Informatica domain in which the workflow runs. The data values in the table or file must match the values in the data source column that you select.
    Include the security domain name with the user or group name. For example, enter
    Native\Jefferson
    to identify the user name Jefferson in the Native domain.
  • If a data value contains a delimiter, use quotation marks as text qualifiers to enclose the data value.
  • You can associate a column value or a range of values with more than one user or group. When the workflow runs, the Data Integration Service assigns any task that contains the value or values to the first user or group in the distribution list.
  • If a record contains a value that does not match the distribution criteria, the Data Integration Service adds the record to a unique task instance. The Data Integration Service assigns the instance to a user or group that you specify on the
    Task Distribution
    tab.
    You can select any user or group in the domain, including any user or group that you select to receive other tasks.

0 COMMENTS

We’d like to hear from you!