Table of Contents

Search

  1. Preface
  2. Components
  3. API collections
  4. Business services
  5. File listeners
  6. Fixed-width file formats
  7. Hierarchical schemas
  8. Industry data service customizer
  9. Intelligent structure models
  10. Refining intelligent structure models
  11. Mapplets
  12. Saved queries
  13. Shared sequences
  14. User-defined functions

Components

Components

Performing actions on multiple nodes

Performing actions on multiple nodes

You can perform actions on multiple nodes. The actions you can depend on the type of sample data that you base the model on and on the output data type of the node.
  1. Search for nodes on the
    Find & Actions
    tab and select the nodes to perform the action on in the
    Results
    list.
  2. From the
    Action
    list, select one of the following actions:
    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.
    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.
    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.
    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.
  3. Click
    Apply to Selected
    .

0 COMMENTS

We’d like to hear from you!