4.
|
|
|
Select All Records to include all records in your input data source.
|
|
Select Records With to select only certain records from your input, based on criteria you define using queries.
|
6.
|
|
Point & Click: This is the default view. Click in the Field Name, Oper., Value, and And/Or column cells to select values to build your query. This tool 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, string functions, and so on.
|
7.
|
If you are constructing a query, select the fields you want to include in your query from the Available Fields list, including IBM® Unica Campaign Generated Fields and Derived Fields. For more information, seeCreating queries in processes.
|
|
If your query includes a table field that has the same name as a IBM® Unica Campaign Generated Field, you must qualify the field name using the following syntax: <table_name>.<field_name>. This syntax indicates that the table field will be used instead of the IBM® Unica Campaign Generated Field.
|
8.
|
|
|
To store the data in a uniquely-named table with a UAC_EX prefix, select an available database.
|
9.
|
|
|
|
|
To change the default output name of a field to extract, select the field in the Fields to Extract list, click on the name in the Output Name column, then enter the new name.
|
|
Profile an available field from a cell, table, or strategic segment, click Profile. For more information, seeProfiling fields.
|
|
|
|
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.
|
|
11.
|
Copyright IBM Corporation 2012. All Rights Reserved.
|