All Forums Data Modeling
Raja_KT 1246 posts Joined 07/09
26 Sep 2013
MOLAP to ROLAP

Hi,

I am planning to replace MOLAP with ROLAP using snowflake. I think I can use a PPI alongwith value order  in AJI for performance in TD 13.10. Should I  remove all foreign keys and primary keys to tables replacing  with unique constraint or UPI and not null?

 

How about adding hard RI and soft RI ? Say I have Product_dim(class_id fk) and Class_dim(class_id pk), Should I use Class_dim(class_id pk) as UNIQUE constraint or UPI  and Product_dim(class_id fk) as just NOT NULL?

 

Thanks and regards,

Raja

Raja K Thaw

My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1

Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.