I have incoming data from 2 source systems which have datatypes of int or uniqueidentifier which relate to the same dimension.
My aim is to keep the solution simple. My current thinking is to have the natural key field on each dim as a varchar and prefix the incoming data which a letter denoting the source system.
This would enable me to join the staged data to the dimension on this column but performance would suffer as I'd be joining on a character field.
How would you guys approach this?