How to Extract Table Based on Join Condition
Problem Summary
How do I extract a table based on a join condition because they are dependent tables?
For example:
select <....> from tab1 t1, tab2 t2 where t1.id=t2.id and modified_date >(select max(date) from tab3)
Answer
This can be done by adding the Restrict action and defining the join condition in the /RefreshCondition parameter as follows:
/RefreshCondition="where id in (select t2.id from tab2 t2 where modified_date > (select max(date) from tab3))"