Join Multiple Tables in GoldenGate 12c

Hi Experts,

Currently I am working on one PoC, where I need to implement join clause between 3/4 tables using GG 12c.

My requirement is as follows :

I have two tables, say EMP and DEPT. Now I have 3rd table in target EmpDept, where I am supposed to Map the data based on the logic. When the dept ID from EMP table and the dept ID from DEPTwill match (where emp.Dept ID = dept.Dept ID) , only then I will map the respected results from the both table to target.

I have read about UPDATEINSERT / OVERRIDEDUP parameters, but don't want to use here. Because my main goal is to join 4 tables in the above way. So I have to use select query with where condition. Basically one particular ID must be present in 4 tables, then only I will Map. This will be my next step. But initially I want test on two tables with a simple join clause.