Table of Contents

Search

Data Transformation Getting Started Guide

Data Transformation Getting Started Guide

Data Processor Transformation Wizard

Data Processor Transformation Wizard

You can use a wizard to create an auto-generated Data Processor transformation with input and output formats such as COBOL, XML, ASN.1, relational, or JSON. You can also use the wizard to transform user-defined formats.
When you create a Data Processor transformation with the wizard, you select the input and output formats. Select from existing formats or create user defined formats. For certain formats, such as ASN.1, XML, JSON, or COBOL, add a schema, specification file, example file or copybook that defines the expected structure for the input or output.
The wizard creates a transformation with relevant Script, XMap, or Library objects that serve as templates to transform the input format to the output format. The Data Processor transformation creates a transformation solution according to the formats selected and the specification file, the example file, or the copybook. The transformation might not be complete, but it contains components that you connect and customize to complete the transformation definition.
After the wizard auto-generates a transformation, use Developer editors to configure and test the transformation components. Define the Data Processor transformation ports on the transformation Overview view.
You can add the transformation to a mapping in Developer. You can also export the transformation as a PowerCenter service and use it as an Unstructured Data Transformation in PowerCenter.