Surrogate key when need


Surrogate key when need


I feel that if I need ;a surrogate key, I can generate from my query itself, even though if my edw is fed from heteregeneous sources, I can identify my sources with constant concatenation.

Also at the reporting side, based on the knowledge of the system, the users can just obtain on the fly.

Please tell me which scenarios I have not covered.

Thanks and regards,