Option | Description |
|---|---|
Add Prefix | Add a prefix to node names. Enter the prefix in the With field. |
Add Suffix | Add a suffix to node names. Enter the suffix in the With field. |
Exclude | Exclude the nodes from the intelligent structure. Data from the node is not part of the output of the model and is not parsed during run time. |
Include | Re-include excluded nodes in the structure. |
Expand | Expand the nodes to show portions of the model that are collapsed under the nodes. |
Collapse | Hide portions of the model that are nested under the nodes. |
Update Data Type | Change the data type of the nodes. Select the data type in the To field. Based on the data type that you select, you can edit the precision, scale, or type format of the nodes. The data type selection applies to an intelligent structure model that you export to Informatica Developer. |
Add Child Prefix | Add a prefix to the child node names. Enter the prefix in the With field. Note: This command only applies prefixes to immediate child nodes. Prefixes don't apply to child nodes further down the node path. |
Add Child Suffix | Add a suffix to the child node names. Enter the suffix in the With field. Note: This command only applies suffixes to immediate child nodes. Suffixes don't apply to child nodes further down the node path. |
Change Type to String | Change the data type of the nodes to string. |
Replace | Replace a string in node names with the string you enter in the With field. Node names are not case sensitive. Names must be unique across sibling nodes, that is, nodes that reside under the same node. |
Discover data type by content | Discover the data type of numbers that are enclosed in double quotes based on the content of the node that contains the data. Applies to JSON files. Note: Once you apply this action to a node or to multiple nodes, you can't select to revert to the default mode of identifying numbers that are enclosed in double quotes as strings. To re-apply the default mode you must select the sample file and discover the structure again. |
Extract Formatted Data | Parse the formatted data that Microsoft Excel shows. Applies to Microsoft Excel files. |
Extract Unformatted Data | Parse the underlying, unformatted data. Applies to Microsoft Excel files. |