Generating a Mapping from a Relational or Flat File Source or Target
Generating a Mapping from a Relational or Flat File Source or Target
You can generate a web service mapping based on a relational or flat file source or target. Use the relational or flat file source or target to define the columns in the web service source and target definitions.
When you generate a mapping from a relational or flat file source or target, the web service mapping generated contains the following objects:
Web service source definition
Source qualifier
Web service target definition
The Designer links the ports from the source instance through the target instance. To complete the mapping, add the transformations and other mapping component necessary for the web service you want to create.
When you generate a mapping from a relational or flat file source or target, create the web service source and target in the same process. When you run a workflow that contains a mapping with the web service source and target created at different times, the workflow can fail.
To generate a mapping from a relational or flat file source or target:
In the PowerCenter Designer, open the Mapping Designer.
Click Mappings > Create Web Service Mappings > Use Source/Target definitions.
The procedure to generate a web service mapping from a relational or flat file source or target is the same as the procedure to create web service source and target definitions from relational or flat file sources or targets. For more information, see Creating a Source or Target Definition.