MOLAP to ROLAP

Data Modeling
Enthusiast

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