When you export the mapping specification target as a table definition, you can select the database type for the table definition. The Analyst tool generates an SQL script that contains the table definition based on the structure of the mapping specification target.

You can download this SQL script and provide it to a developer who can run the script to create the table in a database. In PowerCenter, a developer can use the table to create a table definition in a mapping. In the Developer tool, a developer can import the table as a physical data object to use in a mapping.