hi andy!

above examples are working when primary key column data type is int,but not in case of var char, as i have course in course_dim table,what to do with this...

i triedin new Column in Derived Column

Gender == "1" ? "MALE" : Gender == "0" ? "FEMALE" : "NA"

but i gave NULL values

How do you know the true value of your dirty data? For example, how do you know if "01" is a 0 or a 1?

i checked data in Sql server,n...