Case sensitive tables are not supported in Strategy 9.x. Therefore, the Strategy SQL Generation Engine is not be able to distinguish between the following two different warehouse tables:
Table1:
Time_Zone as varchar
Table2:
TIME_ZONE as varchar
The Structured Query Language (SQL) generated will not reflect the difference in the tables. As a workaround, rename the table columns on the warehouse side respectively to 'Time_zone1' and 'time_zone2'.
NOTE:
Database using case sensitive collation is not supported either. So even if the warehouse is case sensitive, Strategy does not allow more than one table or column with names only different in cases. Architect which is the component reading from Database is non-case sensitive.
