This shows you the differences between two versions of the page.
adding_sources_to_the_data_warehouse [2016/03/01 09:00] markmeteenk created |
adding_sources_to_the_data_warehouse [2018/11/02 14:31] (current) markmeteenk |
||
---|---|---|---|
Line 15: | Line 15: | ||
* Check what data types are used and if they match the data types in the database of the data warehouse. Create a data mapping if needed. | * Check what data types are used and if they match the data types in the database of the data warehouse. Create a data mapping if needed. | ||
* Check the coding (UTF-8, ANSII, etc). | * Check the coding (UTF-8, ANSII, etc). | ||
+ | * Check if source is case (in-)sensitive. Make sure your data warehouse database can cope with case (in-)sensitivity. | ||
Flat file checks | Flat file checks |