|
Getting correct results when using raw SQL in a Select process (that is, the correct list of audience IDs) requires the use of the <TempTable> token when in-DB optimization is enabled and there is an input cell to the Select process. In addition, to significantly improve performance when Campaign processes very large tables, use the <TempTable> token even when not using in-DB optimization.
|
|
If you have chosen to Select All Customer IDs, you can write raw SQL commands to be run against records in a specified database before or after the Select process is executed.
|
|
If you have chosen to apply select criteria to the customer IDs, in addition to the above, you can also enable the use of raw SQL in the Query Builder when creating your select criteria. Otherwise, you can only use IBM® Unica Marketing expressions and Custom Macros.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|