Network
Data Engineering
Data Engineering Integration
Enterprise Data Catalog
Enterprise Data Preparation
Cloud Integration
Cloud Application Integration
Cloud Data Integration
Cloud Customer 360
DiscoveryIQ
Cloud Data Wizard
Informatica for AWS
Informatica for Microsoft
Cloud Integration Hub
Complex Event Processing
Proactive Healthcare Decision Management
Proactive Monitoring
Real-Time Alert Manager
Rule Point
Data Integration
B2B Data Exchange
B2B Data Transformation
Data Integration Hub
Data Replication
Data Services
Data Validation Option
Fast Clone
Informatica Platform
Metadata Manager
PowerCenter
PowerCenter Express
PowerExchange
PowerExchange Adapters
Data Quality
Axon Data Governance
Data as a Service
Data Explorer
Data Quality
Data Security Group (Formerly ILM)
Data Archive
Data Centric Security
Secure@Source
Secure Testing
Master Data Management
Identity Resolution
MDM - Relate 360
Multidomain MDM
MDM Registry Edition
Process Automation
ActiveVOS
Process Automation
Product Information Management
Informatica Procurement
MDM - Product 360
Ultra Messaging
Ultra Messaging Options
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Ultra Messaging Streaming Edition
Edge Data Streaming
Knowledge Base
Resources
PAM (Product Availability Matrices)
Support TV
Velocity (Best Practices)
Mapping Templates
Debugging Tools
User Groups
Documentation
English
English
English
Español
Spanish
Deutsch
German
Français
French
日本語
Japanese
한국어
Korean
Português
Portuguese
中文
Chinese
Log Out
B2B Data Transformation
10.2
10.5.2
10.5.1
10.5
10.4.1
10.4.0
10.2.2 HotFix 1
10.2.2
10.2.1
10.2
H2L
Data Transformation User Guide
B2B Data Transformation 10.2
B2B Data Transformation 10.2
All Products
Rename Saved Search
Name
* This field is required
Overwrite saved search
Confirm Deletion
Are you sure you want to delete the saved search?
Table of Contents
Search
No Results
Preface
Introduction to Data Transformation
Data Transformation Overview
Data Transformation Process Architecture
Data Transformation Components
Data Processor Transformation
Data Processor Transformation Overview
Data Processor Transformation Views
Data Processor Transformation Ports
Data Processor Transformation Input Ports
Service Parameter Ports
Creating Service Parameter Ports
Data Processor Transformation Output Ports
Default Output Port
Pass-Through Ports
Startup Component
References
Data Processor Transformation Settings
Character Encoding
Rules and Guidelines for Character Encoding
Output Settings
Processing Settings
XMap Settings
XML Output Configuration
Events
Event Types
Data Processor Events View
Logs
Design-Time Event Log
Run-Time Event Log
Viewing an Event Log in the Data Processor Events View
User Log
Data Processor Transformation Development
Create the Data Processor Transformation
Select the Schema Objects
Create Objects in a Blank Data Processor Transformation
Creating a Script
Creating an XMap
Creating a Library
Creating Validation Rules
Adding an Example Source
Create the Ports
Testing the Transformation
Data Processor Transformation Import and Export
Exporting the Data Processor Transformation as a Service
Importing Multiple Data Transformation Services
Importing a Data Transformation Service
Exporting a Mapping with a Data Processor Transformation to PowerCenter
Wizard Input and Output Formats
Wizard Input and Output Formats Overview
ASN.1 Library
ASN.1 Protocol Specification
ASN.1 Input Message Structure
Installing the ASN.1 Library
Uninstalling the ASN.1 Library
Upgrading the ASN.1 Library
Creating an ASN.1 Library Transformation
Step 1. Create an ASN.1 Library Transformation with the Wizard
Step 2. Edit the ASN.1 Library Transformation
Installing the ASN-1Step Utility
ASN.1 Streamer
ASN.1 Streamer Properties
AsnToXml Document Processor
Example
ASN.1 Transformers
Viewing Advanced Properties
BCDSwapToString
BCDToString
HexSequenceToDecimal
HexToDecimal
Swap
Avro
Avro Input and Complex File Reader
Avro Data Compression with the Snappy Codec
Updating the Snappy Codec to Enable Avro Data Compression
Configure a Transformation with Avro Input
Step 1. Create a Transformation that Transforms Avro
Step 2. Edit the XMap
Step 3. Configure the Streamer
Step 4. Configure the Complex File Reader
Configure a Transformation with Avro Output
COBOL Processing Library
Creating a Transformation for COBOL
COBOL Data Definitions
Test Procedures
Testing a COBOL Parser
Testing a COBOL Serializer
Editing a Transformation for COBOL
Optimizing Large COBOL File Processing in the Hadoop Environment
Configuring the Complex File Reader for COBOL
JSON
JSON Schemas
Sample JSON Schema
Creating a Transformation with JSON
Parquet
Creating a Transformation with Parquet Input or Output
Configure the Complex File Reader For Parquet Input
XML
Creating a Transformation that Transforms XML
Relational Input and Output
Relational Input and Output Overview
Relational Input
Relational Input Port Configuration
Guidelines to Link Input Ports
Define Input Relational Ports with the Overview View
Clustering_Key Ports
Normalized Relational Input
Pivoted Relational Input
Denormalized Relational Input
Mapping Relational Ports to Hierarchical Nodes
Relational Output
Relational Output Port Configuration
Define Output Relational Ports with the Overview View
Normalized Relational Output
Pivoted Relational Output
Denormalized Relational Output
XMap
XMap Overview
XMap Schemas
Mapping Statements
Mapping Statement Types
Map Statements
Map Statement Properties
Group Statements
Group Statement Properties
Repeating Group Statements
Repeating Group Statement Properties
Router Statements
Router Statement Properties
Option Statements
Option Statement Properties
Default Statements
Default Statement Properties
Run XMap Statements
Run XMap Statement Properties
RunMapplet Statement
RunMapplet Statement Properties
MappletInput Statement
MappletInput Statement Properties
MappletOutput Statement
MappletOutput Statement Properties
Creating an XMap
Using the XMap Editor Grid
Creating Mapping Statements
Mapping Statements Grid Interface
Linking Schema Nodes
Cut and Paste Mapping Statements
XPath Expressions
Predicates
XPath Predicates Reference
XPath Arithmetic Operators
Output XPath Expressions
XPath Expression Editor
Data Processor Functions
XPath Expressions Example
Creating An Expression
XMap Variables
Creating a Variable in the XMap Editor
XMap Example
XML Input Schema Example
XML Output Schema Example
XML Input Data
Input and Output XML Hierarchies
Mapping Statements in the Example
Group Statements Example
Libraries
Libraries Overview
Library Structure
Element Properties
Library Management
Edit Libraries with the Library Editor
Adding an Element with the Library Editor
Editing the Element Properties with the Library Editor
Testing a Library
Generating the Library Objects
Discarding the Library Objects
Edit Libraries with the IntelliScript Editor
Schema Object
Schema Object Overview
Schema Object Overview View
Schema Files
Schema Object Schema View
Namespace Properties
Element Properties
Advanced Element Properties
Simple Type Properties
Simple Type Advanced Properties
Complex Type Properties
Complex Type Advanced Properties
Attribute Properties
Schema Object Advanced View
Creating a Schema Object
Schema Updates
Schema Synchronization
Schema File Edits
Setting a Default Schema File Editor
Editing a Schema File
Command Line Interface
Command Line Interface Overview
CM_console
Scripts
Scripts Overview
Script Components
Component Types
Component Names
Adding a Global Component
Adding a Local Component
Script Component Properties
Simple Properties
Advanced Properties
Component Property Values
Script Startup Components
Setting the Startup Component with the IntelliScript Editor
Example Sources
Example Source Highlighting
Setting an Example Source in the IntelliScript Editor
Viewing an Example Source
IntelliScript Editor
Sample Scripts
Importing a Sample Script
Parsers
Parsers Overview
Platform-Independent Parsers
Newline Markers
File Paths
Parser Component Reference
Parser
Script Ports
Script Ports Overview
Script Port Component Reference
AdditionalInputPort
Example of AdditionalInputPort
AdditionalOutputPort
Defining an Additional Output Port
File Name of Additional Output
Example of AdditionalOutputPort
DocList
FileSearch
InputPort
LocalFile
OutputPort
Text
URL
Document Processors
Document Processors Overview
Defining a Document Processor
Display of Document Processor Output
Document Processor Component Reference
AFPToXML
AsnToXml
ExcelToDataXml
ExcelToXml
ExcelToXml_03_07_10
ExpandFrameSet
ExternalJavaPreProcessor
ExternalPreProcessor
HIPAAValidator
PdfFormToXml_1_00
PdfToTxt_3_02
PdfToTxt_4
PowerpointToTextML
ProcessByTransformers
ProcessorPipeline
RtfToTextML
WordToXml
XmlToDocument_372
XmlToDocument_45
XmlToExcel
XmlToXlsx
TextML XML Schema
PdfToTxt_4 Table Configuration Editor
Editor Options
PDF Conversion Example
Configuring the First Table
Configuring the Second Table
Formats
Formats Overview
Standard Format Properties
Format Component Reference
BinaryFormat
CustomFormat
Example
HtmlFormat
RtfFormat
TextFormat
XmlFormat
Delimiters Component Reference
CommaDelimited
Example
Delimiter
Example
DelimiterHierarchy
Example
Online Sample
EnclosingDelimiters
HL7
Positional
Example
Using Positional Parsing Together with Delimiters
PostScript
RTF
SGML
SpaceDelimited
Example
TabDelimited
Example
Format Preprocessor Component Reference
HtmlProcessor
RtfProcessor
Data Holders
Data Holders Overview
XML Schemas
Schema Encoding
Included Schema Files
Namespaces
Mixed Content
Unsupported Schema Features
Precision of Numerical Data
Using a Schema to Map Anchors
IntelliScript Representation of Data Holders
Mapping Mixed Content
Mapping XSI Types
Generating Valid XML
Role of Schemas in Parsing
Sequence of Elements
Number of Occurrences
Missing or Empty Elements
Data Types
Role of Schemas in Serialization and Mapping
Variables
Creating a User-Defined Variable
System Variables
Variables Used to Access Source Documents
Read-Only Access Variables
Read-Only System Time Variables
Variables Used for Failure Handling
Variables Used for Structured Parsing
Variables Used in Notifications
Mapping Anchors to Variables
Using Variables in Actions
Initializing Variables at Runtime
Variable Component Reference
Variable
Multiple-Occurrence Data Holders
Attributes
Indexing
Destroying the Occurrences
Online Sample
Anchors
Anchors Overview
Marker and Content Anchors
Other Anchor Types
How Anchors and Delimiters Work Together
Mapping Content Anchors to Data Holders
Mapping to Variables
Mapping to Multiple-Occurrence Data Holders
Mapping to Mixed-Content Elements
Defining Anchors
Where to Define Anchors
Sequence of Anchors
Exception: Variable Source Sequence
Adding a Marker or Content Anchor
Defining an Anchor
Standard Anchor Properties
How a Parser Searches for Anchors
Search Phases
Nested Phases
Search Scope and Search Criteria
Adjusting the Search Phase
Adjusting the Search Scope
Phase Property
Marking Property
Online Samples
Adjusting the Search Criteria
Using Data Types to Narrow the Search Criteria
Data Types in Combination with Other Search Criteria
List Data Types
Decimal Type
Type Search with Closing Marker
Online Sample
Disabling the Data-Type Search
Anchors that Contain Nested Anchors
Anchor Component Reference
Alternatives
Example
How to Define an Alternatives Anchor
Using Alternatives to Select a Secondary Parser
Online Sample
Content
Search Direction
Online Sample
DelimitedSections
Example
Optional Sections
How to Define a DelimitedSections Anchor
Online Sample
EmbeddedParser
Example
Online Sample
EnclosedGroup
Example
How to Define an EnclosedGroup Anchor
ExtractRecord
FindReplaceAnchor
Example
How to Define a FindReplaceAnchor Anchor
Group
How to Define a Group Anchor
Optional Group
Online Sample
Marker
How to Define a Marker Anchor
Online Sample
RepeatingGroup
How to Define a RepeatingGroup Anchor
Search for Iterations
End of a RepeatingGroup
Success or Failure of a RepeatingGroup
Event Log of a Repeating Group
Online Samples
StructureDefinition
Example
Subelement Components
Notifications
Keeping Track of Progress
Searcher Component Reference
AttributeSearch
Example
Valid Attribute Syntax
Online Sample
LearnByExample
NewlineSearch
OffsetSearch
PatternSearch
Example
SegmentSearch
TextSearch
Example
Specifying a Search String Dynamically
Online Sample
TypeSearch
Anchor Subcomponent Reference
AllStructure
AllStructureLocal
ChoiceStructure
ChoiceStructureLocal
Connect
Example
EmbeddedStructure
RecordStructure
RecordStructureLocal
SequenceStructure
SequenceStructureLocal
Transformers
Transformers Overview
Defining Transformers
Using Transformers in Anchors
Sequences of Transformers
Default transformers
Using Transformers as Document Processors
Using Transformers in Serialization Anchors
Using Transformers in Actions
Standard Transformer Properties
Transformer Component Reference
AbsURL
AddEmptyTagsTransformer
AddString
Online Sample
Base64Decode
Base64Encode
BidiConvert
CDATADecode
CDATAEncode
ChangeCase
Online Sample
CreateGuid
CreateUUID
DateFormatICU
Example
Supported Formats
Dos96HebToAscii
DynamicTable
EbcdicToAscii
EDIFACTValidation
EncodeAsUrl
Online Sample
Encoder
ExternalTransformer
FormatNumber
FromFloat
FromInteger
FromPackDecimal
FromSignedDecimal
hebrewBidi
HebrewDosToWindows
HebrewEBCDICOldCodeToWindows
hebUniToAscii
hebUtf8ToAscii
HtmlEntitiesToASCII
Supported Entities
Output Encoding for Upper-ASCII Characters
HtmlProcessor
InjectFP
InjectString
InlineTable
JavaTransformer
LookupTransformer
Defining an Inline Table
Storing an XML Lookup Table in a File
Creating an XML Lookup Table Dynamically
NormalizeClosingTags
RegularExpression
Regular Expression Syntax
Preserving Portions of the Original Text
RemoveMarginSpace
RemoveRtfFormatting
RemoveTags
Replace
Online Sample
Resize
ReverseTransformer
RtfProcessor
RtfToASCII
SubString
ToFloat
ToInteger
ToPackDecimal
TransformationStartTime
TransformByParser
Online Sample
TransformByProcessor
TransformByService
TransformerPipeline
XMLLookupTable
XSLTTransformer
Actions
Actions Overview
How Actions Work
Comparison Between Actions and Transformers
Defining Actions
Standard Action Properties
Action Component Reference
AddEventAction
AggregateValues
AppendListItems
Example
Online Sample
AppendValues
Example
CalculateValue
Example
Online Sample
CombineValues
Example
Online Sample
CreateList
Example
CustomLog
DateAddICU
DateDiffICU
DownloadFileToDataHolder
DumpValues
EnsureCondition
Standard JavaScript Syntax
JavaScript Extensions
ExcludeItems
Map
Online Sample
Notify
ResetVisitedPages
RunMapper
RunMapplet
RunParser
Example
RunPCWebService
RunSerializer
Online Sample
RunXMap
SetValue
Sort
Limitation
ValidateValue
WriteValue
Online Sample
XSLTMap
Example
Action Subcomponent Reference
OutputDataHolder
OutputFile
ResultFile
StandardErrorLog
Serializers
Serializers Overview
Controlling How the Create Serializer Command Works
Serialization Mode
Troubleshooting an Auto-Generated Serializer
Root Tag
Variables
Additional Components
Creating a Serializer by Editing the Script
Online Sample
Creating a Serializer within a RunSerializer Action
Serialization Anchors
Example of Serialization Anchors
Sequence of Serialization Anchors
Standard Serializer Properties
Serializer Component Reference
Serializer
Serialization Anchor Component Reference
AlternativeSerializers
Example
ContentSerializer
DelimitedSectionsSerializer
Example
Optional Sections
EmbeddedSerializer
Example
GroupSerializer
RepeatingGroupSerializer
Example
StringSerializer
Mappers
Creating a Mapper
Components Nested within a Mapper
Mapper Example
Source XML
Output XML
Mapper Configuration
Standard Mapper Properties
Mapper Component Reference
Mapper
Mapper Anchor Component Reference
AlternativeMappings
Example
EmbeddedMapper
Example
GroupMapping
RepeatingGroupMapping
Example
Locators, Keys, and Indexing
Overview of Locators, Keys, and Indexing
Example of Locators
Input and Output
Incorrect Solution
Correct Solution
Example of Indexing by Key
Input
Output
Outline of the Transformation Approach
Mapper Configuration
Use of Indexing
Source and Target Properties
Source Property
Default Behavior
Ambiguities in the Default Behavior
Data Holder Must Exist
Using the Source Property for Input or Output
Example 1: Nested Multiple-Occurrence Data Holders
Example 2: Indexing
Target Property
Default Behavior
Ambiguities in the Default Behavior
Data Holder Can Be Created
Using the Target Property for Input or Output
Example 1: Nested Multiple-Occurrence Data Holders
Example 2: Indexing
Standard Locator and Key Properties
Locator and Key Component Reference
Key
Example
Composite Keys
Restrictions on the Key
Sibling and Non-Sibling Occurrences
Keys of Reusable Elements
Enforced Uniqueness of a Key
Locator
LocatorByKey
Conflicts Between Locators
LocatorByOccurrence
Conflicts Between Locators
Streamers
Streamers Overview
Text Streamers
Segments
Simple Segments
Complex Segments
Example
Header Concatenation
Output of a Streamer
Output in Design Environment
Wrapping Output in a Root Tag
Using Markers and Variables in Streamers
Creating a Streamer
Streamer Configuration Example 1
Streamer Configuration Example 2
XML Streamers
Standard Streamer Properties
Streamer Component Reference
ComplexSegment
ComplexXmlSegment
JsonStreamer
MarkerStreamer
Using the Marking Property to Define Segment Boundaries
SimpleSegment
SimpleXmlSegment
Streamer
StreamerVariable
XmlSegment
XmlStreamer
Streamer Subcomponent Reference
AddHeaderModifier
AddStringModifier
DoNothingModifier
WellFormedModifier
WriteSegment
Validators, Notifications, and Failure Handling
Overview of Validators, Notifiers, and Failure Handling
Failure Handling
Using the Optional Property to Handle Failures
Failure Causes Parent to Fail
Optional Failure Does Not Cause Parent to Fail
Rollback
Setting the Optional Property
Components that Lack an Optional Property
Writing a Failure Message to the User Log
Configuring User Log Output
Viewing the User Log
Validators
Standard Validator Properties
Validator Component Reference
AlternativeValidators
EDIFACTValidation
Enumeration
LengthEquals
MaxLength
MaxNumber
MinLength
MinNumber
NumberEquals
ValidateByExpression
ValidateByPattern
ValidateByTransformer
ValidateByType
ValidateDate
ValidatorPipeline
Notifications
Notification Component Reference
Notification
NotificationGroup
NotificationHandler
NotifyFailure
Validation Rules
Validation Rules Overview
Validation Rules Element Reference
Assert Element Attributes
List Element Attributes
Lookup Element Attributes
Lookup File
Rule Element Attributes
Trace Element Attributes
Variable Element Attributes
XPath Editor
XPath Extensions
Example: Using dt:next-sequence()
Edit the Validation Rules in an External Editor
Create a Validation Rules Object
Import a Data Transformation Service with Validation Rules
Custom Script Components
Custom Script Components Overview
Custom Component Example
Custom Component Properties
Developing a Custom Component in Java
Java Interface Example
Sample Custom Java Components
Developing a Custom Component in C or C++
C/C++ Property Value Length Limitation
C/C++ Interface Example
Sample Custom C/C++ Components
Configuring a Custom Component
Sample Scripts Containing Custom Components
Data Transformation User Guide
Data Transformation User Guide
10.2
10.5.2
10.5
10.4.0
10.2.2
10.2.1
Back
Next
WriteSegment
WriteSegment
The
WriteSegment
component copies a segment to a specified output location. The component does not alter the copied segment. The
WriteSegment
component is an option of the
run_component
property of the
XmlSegment
component.
The following table describes the properties of the
WriteSegment
component:
Property
Description
output
Defines the output location. The
output
property has the following options:
OutputDataHolder. Writes to a data holder.
OutputFile. Writes to a file.
OutputPort. Defines the name of an
AdditionalOutputPort
where the data is written.
ResultFile. Writes to the default results file of the transformation.
StandardErrorLog. Writes to the user log. For more information, see
Failure Handling
.
For more information about these options, see
Action Subcomponent Reference
. Default is ResultFile.
Streamer Subcomponent Reference
Updated September 26, 2018
Download Guide
Send Feedback
Resources
Communities
Knowledge Base
Success Portal
Back to Top
Back
Next