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


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 K Thaw

My wiki:

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

You must sign in to leave a comment.