I am assuming that your fact table has a column "Sex". So while importing the data just use this : num(sex) as Sex - > this will change the format to a number. Do the same with the Dimension table as mentioned above:
num(sex) as Sex,
Sex_desc from [LIB://.....];
This should form an association between the fact table and the [Sex Classification] dimension table on the Sex field.