When you use the New Transformation wizard to auto-generate a Data Processor transformation, the Developer tool creates relational ports based on the schema hierarchy, and then links the relational ports to the hierarchical nodes.
Consider the following rules and guidelines when you link relational input ports to hierarchical output nodes:
You can link an input relational port to a node in the hierarchy.
Link a primary key from the relevant element or attribute in the hierarchy to a relational group in the input. The primary key identifies each row in the relational tables.
Link a foreign key from the relevant element or attribute in the hierarchy to a relational group in the input. A foreign key in the relational input is a column in one table that points to the primary key of another table.
The input relational port and the hierarchical node must have compatible data types.
Keys might be of the string type or the integer type.