Using prefixes in the Tables property

When both source and target are among those listed below, you may include a prefix in the target portion of the Tables property. For example, sourcedb.%,targetdb.prefix_% would add prefix_ to the beginning of every target table name, so that table1 in the source would be mapped to prefix_table1 in the target. This syntax can also be used in wizards or adapters when creating schemas in the target prior to initial load.

This option is particularly useful when multiple sources are writing to a target and you want to make sure they don't conflict with each other. Alternatively, instead of creating separate tables with different prefixes for each source, you could have a single target table with a column whose values indicate the source.

Supported sources:

Targets that support table prefixes when the source is one of the above: