How to Extract Table Based on Join Condition

Question

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)

Environment

HVR 5

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))"