Table of Contents

Search

  1. Preface
  2. Components
  3. Business services
  4. File listeners
  5. Fixed-width file formats
  6. Hierarchical schemas
  7. Intelligent structure models
  8. Mapplets
  9. Saved queries
  10. Shared sequences
  11. User-defined functions

Components

Components

Editing the nodes

Editing the nodes

You can change the output by editing the
intelligent structure
nodes.
Perform the following actions to edit nodes on the Visual Model tab:
Rename a node.
To rename a node, right-click a node, select
Rename
, and then type in a name, for example
Street Address
. Node names are not case sensitive.
If you try to rename a node to the name of an existing node,
Intelligent Structure Discovery
does not accept the name change.
Apply unique names to nodes
To apply unique naming across the structure, right-click the root node and select
Apply Unique Naming
. When you apply unique naming to a model, if the data in the sample files contains fields with identical names in different groups,
Intelligent Structure Discovery
uses suffixes to rename identical names to unique names.
Combine data in two nodes.
To join two nodes, click and drag a node to the other node. For example, in the following model, the
time
node is selected and dragged to the
date
node:
The date node is combined with the time node.
The following image shows the combined node:
After you combine the date node with the time node, you have one node named datetime that contains the data from both nodes.
Combine all child node data into a parent node.
To flatten a parent node and merge its child nodes, right-click the node and select
Flatten
. When you flatten a node, the data from the child nodes is merged into one output field for the parent node. The child nodes are no longer separate fields in the output.
Exclude a node from the output.
To exclude a node from the output, right-click the node and select
Exclude from Structure
. When you exclude a node from the model, the data from the node is not part of the output of the model, and is not parsed during run time. To re-include a node that you excluded, right-click the node and select
Include in Structure
.
Change the output data type.
To change the output data type for a node, perform the following steps:
  1. Right-click the node and select
    Open data
    . Alternatively, double-click the node.
  2. In the
    Element Type
    display field, select the data type from the drop-down list of available types and then click
    OK
    .
The data type selection applies to an
intelligent structure model
that you export to Informatica Developer.
Split a node.
To split the data in a node into two nodes, for example, for a credit card number for which you only want to store the last four digits, perform the following steps:
  1. Right-click the node and select
    Split
    . The
    Split
    dialog box appears.
  2. In the
    Split
    dialog box, highlight the data in the display field to indicate where to split the data. The data is split and displayed as two fields, with one field containing the highlighted data, and the second field containing the non-highlighted data.
  3. To confirm the split, click
    OK
    .
  4. To undo the split, click
    Reset
    .
For example, you want to split a node with year-month-date-hour-minute data in one field into two fields. You want to create a year-month-date field and an hour-minute field. The following image shows the highlighted section that you want to split:
In the Split Field dialog box, you highlight the part of the field that you want to split from the rest.
Treat JSON model as repeating
By default, when the sample JSON model does not contain repetitions, the Structure Parser transformation does not parse repeating groups. If you want to parse repeating groups, right-click the JSON root node and select
Treat as Recurring
.
Treat an element as repeating
By default, when an element in the sample JSON or XML model does not contain repetitions, the Structure Parser transformation does not parse repetitions of the element. If you want to parse repetitions of the element, right-click the node and select
Treat as a List
. To undo a
Treat as a List
action, right-click the node and select
Treat as Single
.


Updated August 03, 2020