To use the Hierarchy Builder transformation in a mapping, perform the following steps:
Optionally, create a hierarchical schema.
Add a Hierarchy Builder transformation to the mapping.
Associate a hierarchical schema or an intelligent structure model with the Hierarchy Builder transformation. You can associate an existing hierarchical schema with the transformation or create a hierarchical schema or an intelligent structure model when you configure the transformation.
Optionally, configure additional output settings.
Configure the field mapping to select which relational elements link to the schema or model elements.
Optionally, configure advanced properties.
If you use the Hierarchy Builder transformation in a mapplet, to prevent runtime errors, be sure that the combined Mapplet transformation name doesn't exceed 80 characters. For more information, see
Mapplet transformation names.