4.
|
On the Source tab, select an input cell, a single table, or a strategic segment from the Input list. If you select a strategic segment, associate it with a table by selecting a table from the Select Based On list.
|
|
Select All Records to include all records in your input data source.
|
|
Select Records With to select records based on criteria you define using queries.
|
6.
|
|
Point & Click: Click in the Field Name, Oper., Value, and And/Or column cells to select values to build your query. This method provides the easiest way to create a query and helps to avoid syntax errors.
|
|
Text Builder: Use this tool to write raw SQL or use the provided macros. You can use the Query Helper within Text Builder to select IBM® Unica® macros, including logical operators and string functions.
|
|
If your query includes a table field that has the same name as a Campaign Generated Field, you must qualify the field name using the following syntax: <table_name>.<field_name>.
|
7.
|
|
|
To store the data in a uniquely named table with a UAC_EX prefix, select an available database.
|
8.
|
Select fields from the list of Candidate Fields, and add them to the Fields to Extract list. Use the controls to remove or reorder fields. For information about the fields on the Extract tab, see Extract tab reference.
|
|
|
|
10.
|
11.
|
Optionally, use the Dimension tab to add existing dimension tables to the extract table and specify the key fields to join on. The extract table becomes a base table for the selected dimension tables and can be used in downstream processes.
|
12.
|
Click the General tab to modify the Process Name, Output Cell names, or Cell Codes, link to a target cell, or enter a Note about the process.
|
13.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|