Table of Contents

Search

  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. XMap
  7. Libraries
  8. Schema Object
  9. Command Line Interface
  10. Scripts
  11. Parsers
  12. Script Ports
  13. Document Processors
  14. Formats
  15. Data Holders
  16. Anchors
  17. Transformers
  18. Actions
  19. Serializers
  20. Mappers
  21. Locators, Keys, and Indexing
  22. Streamers
  23. Validators, Notifications, and Failure Handling
  24. Validation Rules
  25. Custom Script Components

Data Transformation User Guide

Data Transformation User Guide

Sample Scripts

Sample Scripts

Informatica
provides sample Scripts as examples of tasks that you can accomplish with a Script.
You can find the sample Scripts in the following subdirectory of the installation directory:
\DataTransformation\samples\Projects
To view, modify, or copy a sample Script, you must first import it.
The following table describes the sample Scripts:
Script Name
Description
Alternatives
Demonstrates branching and the
Alternatives
anchor.
AppendListItems
Concatenates strings in a multiple-occurrence data holder and demonstrates the
AppendListItems
action.
CalculateValue
Performs a complex numerical computation and demonstrates the
CalculateValue
action.
CombineValues
Concatenates strings and demonstrates the
CombineValues
and
DumpValue
actions.
Content
Demonstrates the
Content
anchor and the finding content in the source document by searching for a specific string, by calculating an offset from the last anchor, and by searching for an attribute in a name=value pair.
CopyValue
Copies an entire complex XML element with the
Map
action.
DelimitedSections
Demonstrates the
DelimitedSections
anchor in a Parser.
DocumentOrder
Demonstrates branching and the
Alternatives
anchor, with the
selector
option set to DocumentOrder.
Dynamic_And_RepeatingGroup
Iterates over the lines of a document and demonstrates the
RepeatingGroup
anchor. Reads data from another location in the document based on content in the current scope.
EmbeddedParser
Uses an embedded secondary Parser to parse the content of the main Parser and demonstrates the
EmbeddedParser
anchor.
EnsureCondition
Evaluates a Boolean JavaScript expression to select alternatives and demonstrates the
EnsureCondition
action.
ManualSerializer
Demonstrates a custom Serializer.
Markers
Demonstrates
Marker
anchors that use the TextSearch, OffsetSearch, TypeSearch, and PatternSearch options.
Marking_Mode
Demonstrates multiple methods of configuring
Marker
anchors.
NonMarker
Demonstrates a Parser that uses only
Content
anchors and searching backward through the input document.
Pattern
Demonstrates extraction of data that matches a restriction defined in the schema.
persistent_search
Demonstrates the
on_partial_match
property of a
Group
and the
adjacent
property of a
Marker
.
ResetListVariable
Resets a list variable using a targetLocator.
RunSerializer
Demonstrates a Parser that calls a secondary Serializer.
HL7
Converts an HL7 file to XML.
TabDelimited
Converts a tab-delimited HL7 file to XML.
Splitter
Splits a file into two files, and demonstrates the
WriteValue
action.
TransformByParser
Uses a Parser to transform specific text to carriage return line feed and demonstrates the
TransformByParser
action.
Transformers_Example
Demonstrates the
Content
anchor with the
value
property set to
LearnByExample
.


Updated September 26, 2018