Raw SQL in midstream Select or Segment process requires <TempTable> token

When raw SQL is used in a Select or Segment process with an input cell, Unica strongly recommends using the <TempTable> token to join against the incoming cell IDs. Not using the <TempTable> token might result in longer execution times. In addition, if in-DB optimization is enabled for your flowchart, not using the <TempTable> token might result in incorrect IDs in the output cell (that is, the output cell might contain IDs that are not in the input cell).



IBM Unica Campaign
 
8.5.0
For more information, see our support and community site: Customer Central