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?