Creating a template table

Procedure

  1. Create a database table that contains all possible customized fields that you might want to use in your Unica Optimize sessions.
  2. Create database views for each combination of fields that you want to use in a Unica Optimize session.
    Note: The database table and the database views must exist in the same database where the system tables are located.
  3. Add the new table and database views to the Campaign | partitions | partitionn | Optimize | userTemplateTables | tablenames configuration parameter with a comma delimited list.
    For example, Database1.UACO_UserTable,Database1.view1.
    Note: The names of the table and database views must be fully qualified. For example, database_schema.table_name or database_schema.view_name.