In this entry i am gonna show how to implement an oracle pl/sql statement with subquery condition in ODI 12c.
Environment : ODI 12c & Oracle 11g
Sample Query which i will implement:
group by CUST_ID
having count(order_id) >3
Tables that we are using for this implementation:
Source table 1:
In above you can see the mapping we suppose use for this operation.Trick is hidden inside of the subquery filter object.
ODI already automatically set SRC_ORDERS table as a subquery table.Now only thing we have to do is to set Subquery filter filter properly .( Check the image above).For KMs standart knowledge modules works fine , you dont have to do any change.( For this example LKM Exract and IKM Oracle Global Knowledge modules were used. )