PowerExchange provides a naming convention for data maps.
When you add a data map, you specify the following values:
A schema name, such as
demo
A map name, such as
map1
PowerExchange uses these values to construct the data map name in the format schema.map, for example,
demo.map1
.
You can use the naming convention to group data maps by project, operating system, or other category.
When you run a database row test on a table, PowerExchange generates an SQL statement that contains the table name prefixed with the schema name and map name. The naming format depends on the
DB Type
you select in the
Database Row Test
dialog box and on the setting for the
Use 2-tier names
option on the
Data Maps
tab in the
Preferences
dialog box.
You can use either a two- or three-tier naming convention:
A two-tier name has the following statement:
select * from
schema
.
map
_
table
A three-tier name has the following format:
select * from
schema
.
map
.
table
To use a two-tier naming convention, click
Options > Preferences
. On the
Data Maps
tab in the
Preferences
dialog box, select the
Use 2-tier names
option to use a two-tier name. Clear this option to use a three-tier name.