Retain Data case insensitive from database

Hello,   Is it possible to retain the case sensitive data from SQL server and treat them as unique record, as i would need them as a primary key column to join it with the fact table.    xxxxx...