This content has been marked as final. Show 4 replies
You can go with Materialized view as you said.
We can design in BMM such way that you get only star schema that can be by LTS or for a source physically mapping other tables as said in links.
Dimensions with extensions we go for LTS and other cases like normalised we map them.
Hope this helps, if helps mark
Edited by: Srini VEERAVALLI on Jan 25, 2013 12:11 PM