Effective in version 10.1, when you use an IBM DB2 connection to import a table in the Developer tool or the Analyst tool, you can specify one or more schema names from which you want to import the table. Use the ischemaname attribute in the metadata connection string URL to specify the schema names. Use the pipe (|) character to separate multiple schema names.

For example, enter the following syntax in the metadata connection string URL:

jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>;ischemaname=<schema_name1>|<schema_name2>|<schema_name3>

This feature is also available in 9.6.1 HotFix 4. It is not available in 10.0.

For more information, see the

Informatica 10.1 Developer Tool Guide

and

Informatica 10.1 Analyst Tool Guide

.