In the scenario where we do not have concept of primary/ foreign key in source system such as Snowflake in that case I got to know enforcing primary key in denodo 6 does not assure that i will have unique values for a column or set of columns.What I am actually trying to understand if i enforce primary key in a dimention table, which joins with large fact table. Is it going to help on improving performance.
we have below scenaio( note: source system snowflake does not have concept of primary or foreignt key)
first: joining large dimention with large fact on a column which does not have primary key defined at denodo level
second:joining large dimention with large fact on a column which has primary key defined at denodo level