2 Replies Latest reply on Jun 15, 2015 10:10 AM by Ajo Abraham

    Teradata Multipass SQL

    deepak.ujania

      Is it possible to Use Multiple SQL  passes in terdata data connector using .TDC modifications.

       

      Create volatile table 1 as () ....;

       

      Create volatile table 2 as ()...;

       

      Select table 1 join table 2 on .....

      where

      X = [parameter1];

       

       

      I see that the initial SQL box allows multiple passes but the Custom SQL box does not allow the same.