User Guide

Back Next

Creating a Struct Port

Use the

Create Struct Port

wizard to convert data that passes through one or more ports to struct data.

In the transformation, select one or more ports that you want to convert as elements of the struct data.

The ports you select also determine the elements of the complex data type definition.

Right-click the selected ports, and select

Hierarchical Conversions

Create Struct Port

The

Create Struct Port

wizard appears with the list of ports that you selected.

Optionally, in the

Name

box, change the name of the complex data type definition.

For example, typedef_address.

Optionally, click

Choose

to select other ports in the transformation.

Click

Finish

You can see the following changes in the mapping:

The mapping contains a new Expression transformation

Create_Struct

with a struct output port and a dynamic port with ports from the upstream transformation.

The type definition library contains the new complex data type definition.

The struct output port references the complex data type definition.

The struct output port contains an expression with the STRUCT_AS function. For example,

STRUCT_AS(:Type.Type_Definition_Library.typedef_address,city,state,zip)

Updated January 20, 2020

Send Feedback

Explore Informatica Network