We are stuck with the task of building a warehouse where the major source of data will be SalesForce.
SalesForce uses these large GUID strings (15 to 32 chars).
Would performance be improved significantly if every time we imported into the warehouse, we would first convert the GUID's to unique long integers ?
In that manner, the linkages across the dimensions and fact tables should be much faster.
On top of that, a considerable amount of space would be saved as well.
Is this worth looking into ?