Transformations > Structure Parser Transformation > Intelligent Structures
  

Intelligent Structures

You can create an intelligent structure in Informatica Cloud. When you provide a sample file, Intelligent Structure Discovery determines the underlying structure of the information and creates a model of the structure. After you create an intelligent structure you can view, edit, and delete it. You can associate it with a Structure Parser transformation in a mapping.

Creating an Intelligent Structure

Create an intelligent structure in Informatica Cloud.
    1. Click Configure > Intelligent Structures.
    2. In the Intelligent Structures page, click New.
    3. In the New Intelligent Structure page, enter a name and description. You must provide a name for the intelligent structure.
    4. To create an intelligent structure, browse for a file and click Discover Structure.
    5. To refine the intelligent structure model and customize the structure of the output data, you can select a node and select to combine, exclude, flatten, or collapse the node.
    6. To save the intelligent structure, click OK.

Refining an Intelligent Structure

You can refine the intelligent structure model and customize the structure of the output data.
After Intelligent Structure Discovery creates a model, the model is displayed in the Visual Model tab.
    1. If the message itself has very lengthy rows of data, you can select to view the message in word wrap format, so that all the elements of each row appear within the message display panel while you work. If you do not word wrap, only part of the row is displayed. To wrap text, select Word wrap.
    2. If an intelligent structure model is large, you can collapse nodes the Visual Model tab while you work. When you collapse nodes, all sub-nodes remain in the model but are not displayed. To collapse a node, right-click the node and select Collapse.
    Collapsed nodes contain a plus symbol. To view the sub-nodes, click the plus symbol.
    If the model contains a large table, it is displayed in collapsed format. To view the table sub-nodes, click the plus symbol.
    3. To join a node to another node, for example a street address number and street name, click and drag a node to the other node.
    4. To rename a node, double-click a node and type the node name, for example Street Address.
    5. To flatten a node and merge its sub-nodes, right-click the node and select Flatten.
    When you flatten a node, the data from the sub-nodes is merged with data from the parent node. The sub-nodes are no longer part of the model.
    6. To exclude a node, right-click the node and select Exclude.
    7. To re-include a node that you excluded, right-click the node and select Include.
    8. To split the data in an element between two elements, perform the following steps:
    1. a. Right-click the element and select Split.
    2. b. Highlight the data in the display field to indicate where to split the data. The data is displayed as two fields.
    3. c. To confirm the split, click OK.
    4. d. To undo the split, click Reset.
    9. To work with the data in a table format, select the Table tab.
    1. a. To rename a column, click the column and type the column name, for example City.
    2. b. To exclude a column, right-click the column and select Exclude from Structure.

Editing an Intelligent Structure

After you create an intelligent structure you can change the model.
    1. Click Configure > Intelligent Structures.
    2. In the Intelligent Structures page, click the Edit icon next to the name of the relevant intelligent structure.
    3. In the Edit Intelligent Structures page, you can change the name, description, and model. You must provide a name for the intelligent structure.
    4. To change the intelligent structure model, you can select a node and select to combine, exclude, flatten, or collapse the node.
    5. To save the intelligent structure, click OK.

Deleting an Intelligent Structure

Delete an intelligent structure if you do not need to use it. Before you delete an intelligent structure, verify that no one in the organization plans to use it.
    1. Click Configure > Intelligent Structures.
    2. On the Intelligent Structures page, click the Delete icon next to the name of the relevant intelligent structure.
    Note: If an intelligent structure is used in a mapping, you cannot delete it.