Mapping Specification Export to a Table Definition
Export the mapping specification target as a table definition that developers can use to create a table in a database.
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.
Exporting a Mapping Specification to a Table Definition
Export a mapping specification to a table definition that a developer can use to create a table in a database.
1. From the Actions menu, select Export.
The Export wizard appears.
2. Select Table Definition.
3. Click Next.
4. Select a database type.
5. Click Finish.
The Analyst tool displays a pop up to open or save an SQL script file.