Questions for Asssociation
I have one view (v) creating by one fact table (Table F) left join several dimension tables (Table A, B, C, D), I define PK for the fact and all dimesion tables.
I have not defined associats for them, when I ran this: "select count(*) from v",
I can see only the fact shown in the pushed down query, can I understand, for the left join, if the join key are the PK of dims, I have no need to create associations, and then the non-required dims will not be shown on my pushed down query all the time. That means, in this kind of case, no need to create associations.