I am using DTS to draw data from a Simplified Chinese SQL Server data source. My warehouse, for some reason, needs to be oracle. However, the data got screwed up in Oracle (since it's designed for some other languages/encoding e.g. Traditional Chinese, English...)...What can I do to welcome data from all languages while keeping Oracle as my data warehouse? Any method that I can like 'type cast' my data to unicode and then put in Oracle?
Situation becomes even worse when my Analysis Services draw data from Oracle (already corrupted!)...my cube generated contains nothing but ????