|
Hello Team, We need your assistance in below scenario. Scenario: We have a case sensitive schema name (e.g “Schema_Name”), due to this reason we have to put schema name in double quotes. Now, we have to connect the postgreSQL server via “informatica on cloud”. For the connection from
informatica to Postgress we are using JDBC connection. Problem: While connecting to the server via JDBC connection, “Informatica on cloud” do not take case sensitive schema names due to which we are not able to fetchtables from the schema. Could you please suggest any alternative solution
that can either give non-case sensitive alias to our case sensitive schema or how to make our schema case insensitive. Note: The existing schema is old schema so we don’t have the option to
drop and re-create new schema. Regards, Mayank |
