Dear friends, the whole discussion was interesting to learn, but for a small developer like me, its cumbersome to use guid as a single query run to look for a particular id in the table having 3 lacks record takes more considerable amount of time than using integer.
Also when I use the lookup in MS BIDS and the column is guid, i suspect it takes too much time.
Thanks,
Jwalant Natavarlal Soneji