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, IBM® 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).