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.