SSIS - SSAS Handling String Representation Values

by SGuard   Last Updated October 03, 2017 22:06 PM

I'm not quite sure what the proper name for these kind of values are, but I have some csv files with number values and a data guide with small strings some of these values represent.

My question is, in a solution combining SSIS and SSAS (reading the values and then displaying them as part of queries) what is considered the best practice:
To store these values as string-type numbers and convert them to their representative values during extraction, or to store them as numbers and convert / match them in SSAS?



Related Questions




PostgreSQL 9.3: Index on to_char()

Updated June 16, 2015 04:02 AM

How to get one complete column in mysql?

Updated April 21, 2017 19:06 PM

Why is to_char left padding with spaces?

Updated June 08, 2017 20:06 PM