Updating record counts and lists of distinct values

Use the Unica Campaign session utility (unica_acsesutil) to update record counts or lists of distinct values, as well as to schedule automatic re-computation of those counts.

Three parameters are available to indicate what type of counts to re-compute:

  • -n -- recompute record counts only
  • -l -- recompute list of distinct values only
  • -a -- recompute record counts and list of distinct values for all tables

Use these options to recompute all record counts and/or list of values for a session (-s) or for a catalog (-t). You can combine these options with other options such as import (-i).

To recompute counts for all mapped tables in a flowchart

unica_acsesutil -s sesFileName -i importFileName
[{-a | -n | -l }][-S Datasource -U DBUser -P DBPassword]

To recompute counts for tables in a table catalog

unica_acsesutil -h <partitionName> -t catFileName
[{-a | -n | -l }][-S Datasource -U DBUser -P DBPassword]
Note: You must specify the parameters that define the database connection (-S, -U, -P) if the connection information is not stored in the flowchart.