Creating a Write Transformation from an Existing Transformation
Creating a Write Transformation from an Existing Transformation
You can create a Write transformation with the same ports in a transformation that exists in the mapping.
You can create a target for complex files, flat files, or relational resources. If one of the ports in the existing transformation contains a complex port, you must create a complex file target and link ports by name or link ports at run time based on the link policy. The Developer tool can create an Avro, Parquet, ORC, or JSON complex file target.
Open a mapping in the editor.
Right-click a transformation in the mapping editor and select
Create Target
.
The
Create Target
window opens.
Choose the data object type as Complex File, Flat File, Relational, or Other.
If you choose
Other
, select the required target object type from the list.
Choose a link type.
You can choose from the following link types:
Link ports by name
Ports in the Write transformation correspond to those in the source and have the same names.
Link dynamic port based on the mapping flow
The Write transformation contains dynamic ports based on upstream objects in the mapping flow.
Link ports at run time based on link policy
Ports are created in the target at run time based on the link policy that you configure on the Run Time Linking tab of the Write transformation.
For more information about dynamic ports and run-time link configuration, see the
Informatica Developer Mapping Guide.
Name the new data object.
Optionally, click
Browse
to select a location for the data object.
If you chose to create a complex file target, select the complex file format as Avro or Parquet in the
Resource Format
drop-down box.
Click
Finish
.
The Developer tool performs the following tasks:
Adds a Write transformation to the mapping.
The following image shows a Write transformation created from a Read transformation:
Links ports.
Creates a physical data object.
You can configure the physical data object properties. For example, you must specify an HDFS connection for the complex file data object.