Hi Stefan,

thanks again for the response.

I'll use your feedback!

Kind regards

Hi Stefan,

never mind my surrogate vs compound key for a fact table.

I allready understand there are some etl advantages for using this as a primary key for the fact table.

Kind...

Hi Steven,

thanks for your reply!

If I understand you correctly, the columns with the business keys in the fact table will ALLWAYS slow performance, even though they will never be included...