Surrogate key when need

Analytics
Enthusiast

Surrogate key when need

Hi,

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,

Raja