When I work with MySQL databases for example, I get integrity restriction by declaring:
- SET FOREIGN_KEY_CHECKS = 1;
- Foreign keys, for example
Key_DimProductFOREIGN KEY (
key_dim_product) ON DELETE RESTRICT ON UPDATE RESTRICT
I could not find a way to declare foreign keys. In order to test the consistency of the data, I created a DW and in one of the dimension tables I was able to remove a parent record to which it refers to a child record in the fact table. How could I protect these relationships directly in the MemSQL DBMS?