SYMPTOMS:
Sometimes it is necessary to migrate warehouse databases from one platform to another and. As a result doing so databases may become case sensitive.
Presently, case sensitive databases are not supported by Strategy as described in KB5521 and in such cases the destination database should be rebuilt to non-case sensitive database and migrated again.
Against case sensitive databases Strategy does not work correctly, as, for example, when a filter on an element is used the SQL produced by Strategy to filter on this element would be in lower cases, when the equivalent element on the data warehouse would be in upper cases. This would lead to an empty result set.
CONFIGURATION:
WORKAROUND:
Instead of rebuilding the entire database, two parameters can be changed on the Oracle database: Change the value of NLS_COMP to LINGUISTIC Change the value of NLS_SORT to BINARY_CI
This can be done in Oracle through the "ALTER SESSION" command, as for example:
ALTER SESSION SET NLS_SORT = 'BINARY_CI' NLS_COMP = 'LINGUISTIC';
For a more detailed explanation of these parameters please consult Oracle documentation.
After this change, query submitted to Oracle will ignore the particular case of its content, and Strategy will be able to fetch its content.
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
