Configuring profiling when mapping user tables

When you map a user table, you can either pre-compute the distinct values and frequency counts for specific fields, or allow users to perform real-time profiling of data in the base record table.

About this task

Profiling enables users to see a table's values when editing a flowchart, without having to view raw data and allows users to easily select from valid values when building a query. Pre-computed profiles provide quick access to the distinct field values and counts without querying the database. Real-time profiling provides access to the most up-to-date data and may be helpful if your database updates frequently. If you pre-compute profiles, you can control how often profiles are regenerated.

You can choose to both pre-compute profiles and allow users to dynamically profile in real-time, or you can choose to disallow real-time profiling and force users to always use the pre-computed profiles.

Procedure

  1. When mapping a user table, check the fields for which you want Unica Campaign to pre-compute distinct values and frequency counts.

    By default, Unica Campaign stores the pre-computed profiles in the Campaign > partitions > partition[n] > profile category as data source_table name_field name.

  2. If you have distinct values and counts stored in a separate database table that Unica Campaign should use, click Configure Data Sources. Select Data pre-defined in a table, select the table name, the field containing the values, and the field containing the counts. Then click OK.
  3. Check Allow real-time profiling to have Unica Campaign update its records of values for the selected fields in real-time. This option allows users editing a flowchart to see the current values for these fields. However, it also requires a database query each time a user clicks Profile, which can potentially degrade performance.
    Note: Enabling or disabling the Allow real-time profiling option applies to all table fields, not just the checked ones.

    If you disallow real-time profiling and do not specify an alternate means for pre-generated profiles, users will not be able to view any values or counts for any fields in this table.

    If you disallow real-time profiling and provide pre-computed profiles for one or more fields, users will be able to access the pre-computed profiles, which is for the entire table. Users will not be able to profile only the values for the input cell of a process.

    To provide the greatest flexibility, you should allow real-time profiling.