Hello everyone,
I have a question. I am creating a mapping / interface on ODI 12c. I have some tables to join and conditions belongs to each. One table has such a condition;
join ra_customer_trx_all ct on ctl.customer_trx_id = ct.customer_trx_id
and ct.org_id=23
and ct.batch_source_id not in (select batch_source_id
from ra_batch_sources_all
where name like '%KHÇ%')
There is a subquery condition. How can I model it on ODI. In the filter window, only main table exists. In order to take batch_source_id column from ra_batch_sources_all table, shoul I join or how?
Regards,
Dilek