This content has been marked as final. Show 3 replies
We need to consider snowflake schema in BMM layer not in Physical layer and its rare in BMM layer.
Go with joins as mentioned for Physical layer and coming to BMM for logical table Dim E try to add Dim F as 2nd logical source else
physically map to the Dim E (Using Properties and then use Add button)
Its all depends on your data.
Hope this helps, if helps pls mark
Thanks for your reply.
However, I am still confused. I tried with creating an Oracle view and join it directly with my fact table and it worked fine. I also tried to create logical tables with my joins when you suggested. The thing is the view seems to be quicker when I try to retreive my data than the logical tables.
I would thought that the view would be much slower as we cannot create indexes between a view and an Oracle table (here my view is my dimension and the Oracle table is my fact table).
Any thoughts ?