By default in mappings, database table names are identified by the broker default schema and are in the format: Database.table_name. However, if you define a schema for your application, and define tables within the schema, the table names must be prefixed with the schema name to produce the following format: Database.schema_name.table_name. The following steps show you how to define the schema name globally.
You can also define the schema name for an individual table in a mapping file as described in Adding a database mapping input and Adding a database mapping output. Defining a schema for an individual table overrides the definition in the Preferences dialog box.