What are user tables?

User tables are tables that contain data that you use in processes within a Unica Campaign flowchart. You can map user tables to tables in a relational database or to ASCII flat files.

Note: Before mapping a user table in Unica Campaign, ensure that the table uses only data types that Unica Campaign supports. For a list of supported data types for each database, see Supported data types for user tables.

Typically, a user table contains data about your company's customers, prospects, or products. For example, a user table might contain columns for customer account data such as Account ID, Account Type, and Balance. You might want to use this data in a campaign that targets customers with certain account types and balances.

There are three types of user tables: Base tables, Dimension tables, and General tables.