Analytics Software

Hi everybody,

just a quick question. What might be a way or the best way to realize the following SQLs with ODI (11.1.1.7).

It seems that SQLs with EXISTS / NOT EXISTS are unexpectedly hard to realize.

--Q1

SELECT a.*

  FROM tab_a a WHERE EXISTS (

       SELECT 1 FROM tab_b b WHERE a.x_id = b.x_id)

   AND a.cdate <= to_date('2012-03-01','YYYY-MM-DD')

   AND ( a.mdate IS NULL

       OR a.mdate >= to_date('2012-03-01','YYYY-MM-DD'));

--Q2

SELECT a.*, 'X' dataflag

  FROM tab_a a WHERE NOT EXISTS (

       SELECT 1 FROM tab_b b WHERE a.x_id = b.x_id

          AND b.mdate IS NULL )

  AND a.logicflag <> 'Y';

Regards,

Jens