For Norbertk: no, the join key is my dim primary key.
I possibly update other dim columns if dim key already exists or I insert a new dim record if dim key does not exist.

hello, I have a pre-join projection for a Fact table, with a Dimension table. I notice that when I update my Dimension table through a Merge statement, the pre-join projection is updated too. I saw this in the Result of'the Explain on the merge query and also by the fact that dimension update takes ...