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. 

Thank you

Priya