Studio Schema Exporter

Studio Schema Exporter (technical preview) transforms a hierarchical structure in Talend Data Mapper to an XML Flat Studio Schema stored in one or multiple XML files.

Studio Schema Exporter (technical preview) is equipped with a flattener algorithm based on the main loop branch. The main loop branch refers to a chain of looping nodes in the input structure that defines the output looping expression in the final mapping.

Exporting your structure using the Studio Schema Exporter (technical preview) feature can result into multiple output schemas.

You can manually configure the parameters of the Studio Schema Exporter (technical preview) feature through the Preferences window. From Talend Data Mapper, click Window > Preferences > Mapping > Studio Schema Exporter to open the Studio Schema Exporter window:

The following lists the elements in the Studio Schema Exporter window:

• Shorten generated column names: reduces the schema name length.
• Allow multiple outputs for looping elements: allows you to obtain multiple flattened output structures.
• Allow multiple outputs for choice elements: splits choice elements composed by complex looping to multiple output schemas.
• Maximum number of multi outputs: helps you manage multiple output schemas; specifies the maximum number of generated flattend schema.
• Multiple outputs common columns policy: helps you manage multiple output schemas; allows you to select the method to join different output schemas with the root schema.
  When you select this option, you can choose either of the following methods:

  • None: no extra column is added.
  • Direct siblings: the parent primitive field is added to the output schema.
  • All siblings: the parent primitive field and the record primitive field are added to the output schema.
  • Generate column: a new column, AUTO_GENERATED_FIELD, is added.
• Allow concatenation for primitive looping elements: concatenates all the values of primitive looping elements (arrays that have the primitive type) in one field.
• Use maximum occurrence of looping element when defined: uses the maximum occurrence when it is defined to create a new column in the output schema.
• Maximum number of items for looping elements: specifies the number of N-first values to keep from the looping elements.
• Specify a maximum depth for the main looping branch: modifies the depth of the main loop.

  When you select this option, you can modify the following:

  • Maximum depth for the main looping branch: refers to the size of the main loop.
  • Output branch depth threshold: specifies the minimal depth needed to treat secondary branches in a separate output schema.