Oracle^® Marketing Segmentation Guide > Designing Marketing List Formats >

Managing List Generation Jobs

The Write List Files marketing job represents a list generation job for full output list generation or preview for the following:

• Writing List Output to Multiple Tables
• Writing List Files to Oracle Content Server

Writing List Output to Multiple Tables

Multiple database insert statements are generated with a common select clause from the list format columns. The list format is created with Database selected as the Repository Choice in the list format Options tab and by adding appropriate destination table.column database field names in the Alias column property of all list format columns.

The following check boxes are available from the list format Options tab:

• Generate Writeback Count: Add writeback count for each table in the job output.
• Include duplicate records: Add or remove DISTINCT clause in the common select statement.

In some situations, for every member in a segment, one record should be created in some tables and multiple records in other tables. This is achieved by selecting the Multiple System Attribute Values check box in the Edit Column Formula screen for the appropriate list format columns. The multiple values are passed through System Attributes data as comma separated values at run time.

To generate unique numeric row ids for any column in a table, use the ROW_NUM_ID system attribute from the System Data dialog in the list format column formula.

Writing List Files to Oracle Content Server

You can write list files output to a configured Oracle Content Server repository.

The response from the content server is a contentId which is stored in the marketing job details and can be used for getting saved file data from the content server. The list format should have the Content Server option selected as the Repository Choice in the Options tab along with the appropriate parameters.

The following fields in List format Options tab are applicable in the content server section:

• Content check-in type: The type of the file. These types are predefined on the content server.
• Security group: The security group is a set of files with the same access permission.
• Title: A descriptive name identifying the list file.
• Account: An Account can be accessed by users having Account access permissions.

The Oracle Content Server connection and authentication details are configured using the Enterprise Manager user interface.