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
If helps pls mark
x_abc is already there in BMM layer joined with fact table . If i created a new logical table with source y_abc and adding x_abc by providing outer join here, do i need to add z_abc here?
2) one more thing is that y_abc(new logical table) ,x_abc are in BMM now. do i need to maintain a join in bmm for these tables.
Can you please guide me on this
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.
hope this helps