Logical Facts in BMM
Thanks for your response Srini.
In BMM layer we had only one Measure Logical folder under that multiple Logical Fact tables. in that LTS , we have alias LTS also mapped from Physical Layer to BMM Layer.
As per your Answer..do we need to count main Fact and alias Fact table sources are different star schemas?
Ex : WC_LIABILITY_F, WC_LIABILITY_F promo, WC_RESOLUTION_F, WC_RESOLUTION_F checkpayment.
in the above example all are mapped to Measure folder and had same fact table with alias also present.
1 person found this helpful
Good point. Its all you want to treat them.
WC_LIABILITY_F, WC_RESOLUTION_F these can be the main schema
WC_LIABILITY_F promo, WC_RESOLUTION_F checkpayment these can be the value based schema
there might be other schema which is level based schema generally aggregate
these value and level based schemas are top of main schema
all depends on how data is stored and configured in BMM, so choice is yours how you want count them