Hello,
I have two data sources 1)Snowflake 2)Oracle
snowflake has 4 tables(2 fact 2 dim) Oracle has 1 dim
as per my requirement, I have to join snowflake dim to oracle dim in physical
and in bmm, I am bringing oracle dim columns as separated LTS in the snowflake dim(1st LTS IS snowflake table , 2nd lts (join between snowflake table and oracle table)
when I generate the report with all the columns, I expect obiee fires 2 queries(1 for snowflake and 1 oracle) , but obiee is firing 3 queries
- all the snowflake tables except the dimesion table that joined with oracle
2)only snowflake dimesnion table(which it is supposed to be in the 1st query) without any joins
3)oracle dimesnion
because of 2 nd query, the report keep on running, as it doesn't have any join and I assume it is doing full outer join
how to model in rpd in such a way, obiee fires only 2 queries?