Bookshelf v7.5.3: Mapping an Analytics Subject Area Table in Siebel Marketing

For Target Group segmentation, the segment filter criteria are built against a specific subject area. This subject area is also the source of the customer name and address information that is loaded into the campaign. To support this load process, you need to map the Analytics subject area as a logical table in the Marketing Administration screen in the External Data Mapping view. For more information about how to map tables, see Mapping to Tables from the Servers View Tab and Working With Tables.

After mapping, the data dictionary will process retrieve all the logical columns from the subject area displaying the format "Table_name"."Column_name". Use the following guidelines when you complete a new record in the Tables list.

Table 22. Fields in the Tables List
Table Column	Description
Reference Name	When mapping tables, the reference name can be any name that you choose. However, you need to check other tables in the Siebel transactional database to obtain the necessary table owner syntax for specifying value in the Table Name column. Reference names for tables that contain any special characters must be enclosed in double quotes. Special characters include spaces and Unicode characters.
Table Name	The value in this field must match the name of the subject area in the Analytics repository. Reference names for tables that contain special characters must be enclosed in double quotes, for example "Subject Area". Special characters include spaces and Unicode characters.
Table Type	The default value is Regular. Select Analytic Adapter from the Table Type drop-down list.