5 Replies Latest reply on Aug 21, 2012 2:08 PM by 560935

    Populate target table with default value

    560935
      I have a query like this:
      SELECT 0 AS ID,
      9999999999 AS CODE
      FROM DUAL
      UNION ALL
      SELECT VEH.TP_ID AS ID,
      VEH.VEH_ID AS CODE
      FROM TB_VEHICLE;

      So I have an interface with two data sets, one for each query.

      The first data set represents the "select from dual" "constant values" and the second represents the "select * from tb_vehicle".

      In the first data set I don´t have a source, then ODI generates a select without a table "select 0 AS ID, 99999 AS CODE FROM".

      Any ideas on how can I achieve my objective? I need to populate one row on target table with constant values.

      Thanks