Can your data warehouse automation solution correctly handle international character sets?
I was reading an interesting blog post from SAS at the weekend. It shows how they visualise data containing character sets from many languages around the world.
The blog discuss loading and visualising data that looks like this:
Given that the data is contained in a spreadsheet, I thought it would be fun to see how that data was handled by Ajilius.
Create a data source that points to the spreadsheet:
Ingest the metadata from the spreadsheet:
Run the load script, and here is the result:
There it is. Fast, full-fidelity representation of the SAS data. If you’re building a data warehouse in Korea, or Armenia, or Israel, or any other country with a non-ASCII language, then Ajilius is your best solution for data warehouse automation.
Ajilius. Data warehouse automation for the global community.