Well, the unintended benefit is now I am using int\big int as surrogate keys

for all tables (preferred in DW).

All joins are made on integer data types. Query efficiency is also improved.

The string matching using upper() is done only on ETL when comparing source and target data.