Please find the below query here and i want to design the rpd for below one
y_abc a,Z_abc b
and a.column1=b.column1) N
How to achieve it.
Totally i have 3 tables here. 1 is in main query and other 2 are in sub query. Based on the subquery results main query will be executes .
Create the below joins in Physical layer
y_abc ->Z_abc b
In BMM layer create logica table with source y_abc and then General properties-> Add
other 2 tables and set out join for relation y_abc ->x_abc
once you done this pull/add required columns from Physical layer
I'm not sure what is there in your BMM. I'm just telling how it suppose to be.
What ever you do make sure that on logical table source 'y_abc' general properties you should see other tables added with 1 inner join and other is with outer join.