To all,
I am adding several new star schemas to an existing data warehouse (MSTR 7.2.2/Oracle 9i). My predecessor used DB views to handle shared dimensions. Since performance is not great, I thought about using new column aliases (in the attribute form).
Is that a good practice? Will this work? I assume that if I don't handle this somehow that MSTR will blow up somewhere...cross joins across fact tables or some kind of circular join.... Is this a good alternative? Any other suggestions?
Thanks in advance.
Dave
I am adding several new star schemas to an existing data warehouse (MSTR 7.2.2/Oracle 9i). My predecessor used DB views to handle shared dimensions. Since performance is not great, I thought about using new column aliases (in the attribute form).
Is that a good practice? Will this work? I assume that if I don't handle this somehow that MSTR will blow up somewhere...cross joins across fact tables or some kind of circular join.... Is this a good alternative? Any other suggestions?
Thanks in advance.
Dave