This discussion is archived
5 Replies Latest reply: Aug 21, 2012 7:08 AM by 560935 RSS

Populate target table with default value

560935 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points