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
- Startup Component
- References
- Data Processor Transformation Settings
- Events
  - Event Types
  - Data Processor Events View
- Logs
- Data Processor Transformation Development
- Data Processor Transformation Export and Import
- Data Processor Transformation Validation
  - Using a Speed-enhanced Data Transformation Engine for VRL Validations
- Data Processor Transformation in a Non-native Environment
Wizard Input and Output Formats
- Wizard Input and Output Formats Overview
- COBOL Processing Library
- JSON
- XML
  - Creating a Transformation that Transforms XML
Relational Input and Output
- Relational Input and Output Overview
- Relational Input
- Relational Output
Using the IntelliScript Editor
- IntelliScript Editor Overview
  - Creating a Script
- Opening an IntelliScript Editor
- Editing Procedures
- IntelliScript Editor Menus
XMap
- XMap Overview
- XMap Schemas
- Mapping Statements
- XPath Expressions
- XMap Variables
  - Creating a Variable in the XMap Editor
- XMap Example
Libraries
- Libraries Overview
- Library Structure
- Element Properties
- Library Management
- Edit Libraries with the Library Editor
- Edit Libraries with the IntelliScript Editor
Schema Object
- Schema Object Overview
- Schema Files
- Schema Object Overview View
- Schema Object Schema View
- 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
- Script Component Properties
- Script Startup Components
  - Setting the Startup Component with the IntelliScript Editor
- Example Sources
- IntelliScript Editor
- Validate a Script
- 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
Document Processors
- Document Processors Overview
- Defining a Document Processor
  - Display of Document Processor Output
- Document Processor Component Reference
- 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
- Delimiters Component Reference
- Format Preprocessor Component Reference
  - HtmlProcessor
  - RtfProcessor
Data Holders
- Data Holders Overview
- XML Schemas
- Using a Schema to Map Anchors
- Generating Valid XML
  - Role of Schemas in Parsing
  - Role of Schemas in Serialization and Mapping
- Variables
- Variable Component Reference
  - Variable
- Multiple-Occurrence Data Holders
Anchors
- Anchors Overview
- Mapping Content Anchors to Data Holders
- Defining Anchors
- Standard Anchor Properties
- How a Parser Searches for Anchors
- Anchor Component Reference
- Searcher Component Reference
- Anchor Subcomponent Reference
Transformers
- Transformers Overview
- Defining Transformers
- Standard Transformer Properties
- Transformer Component Reference
Actions
- Actions Overview
- Standard Action Properties
- Action Component Reference
- Action Subcomponent Reference
Serializers
- Serializers Overview
- Serialization Anchors
  - Example of Serialization Anchors
  - Sequence of Serialization Anchors
- Standard Serializer Properties
- Serializer Component Reference
  - Serializer
- Serialization Anchor Component Reference
Mappers
- Creating a Mapper
- Components Nested within a Mapper
- Mapper Example
- Standard Mapper Properties
- Mapper Component Reference
  - Mapper
- Mapper Anchor Component Reference
Locators, Keys, and Indexing
- Overview of Locators, Keys, and Indexing
- Example of Locators
- Example of Indexing by Key
- Source and Target Properties
  - Source Property
  - Target Property
- Standard Locator and Key Properties
- Locator and Key Component Reference
Streamers
- Streamers Overview
- Text Streamers
- XML Streamers
- Standard Streamer Properties
- Streamer Component Reference
- Streamer Subcomponent Reference
Validators, Notifications, and Failure Handling
- Overview of Validators, Notifiers, and Failure Handling
- Failure Handling
  - Using the Optional Property to Handle Failures
  - Writing a Failure Message to the User Log
    - Configuring User Log Output
    - Viewing the User Log
- Validators
- Standard Validator Properties
- Validator Component Reference
- Notifications
- Notification Component Reference
Validation Rules
- Validation Rules Overview
- Validation Rules Element Reference
- 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
  - Java Interface Example
  - Sample Custom Java Components
- Configuring a Custom Component
  - Sample Scripts Containing Custom Components

User Guide

10.5
- 10.5.6
- 10.5.2
- 10.4.0

Back Next

XPath Extensions

The Rule, Assert, List, Variable, and Trace elements can contain XPath expressions. The following functions can be part of the XPath expression.

The Validation Rules object defines the following functions as extensions of XPath 1.0. The extensions belong to the

namespace, which is defined as

http://validations.informatica.com

Function	Description
dt:all-equal( param1[, param2, ...])	Returns true if all items in the list are equal. The parameters can be simple values or lists.
dt:check-uniqueness( value1[, value2, ...])	Returns true if all values in the list of parameters are unique. Each value can be: A simple value A variable that contains a list of strings A variable that contains a list of nodes where each node is a simple value.
dt:date-add( startDate, format, numberOfDays)	Returns the date. If numberOfDays is of type float , the function rounds down the value to the next lower integer.
dt:date-diff( startDate, format, endDate, format)	Returns the number of days between two dates.
dt:date-format( date, inputFormat, outputFormat)	Converts the format of date from inputFormat to outputFormat .
dt:date-valid( string-to-match, format)	Returns true if the string matches the specified date format.
dt:deep-equal( element1, element2)	Returns true if both of the following are true: element1 and element2 have all the same attributes, with all the same values. element1 and element2 have all the same child elements, in the same order, and all the child elements are deep equal.
dt:empty( xpath)	Returns true if an XPath contains no child elements.
dt:exist( xpath)	Returns true if an XPath exists. Equivalent to count(xpath) > 0 .
dt:is-sorted-lex( ascending, param1[, param2, ...])	Returns true if the list items are lexicographically sorted. The first parameter is a Boolean that sets the sort direction: true for ascending or false for descending.
dt:last-day-of-month( date, format)	Returns the last day of the selected month.
dt:list-items( list, separator)	Returns a string of all the items in the list, separated by the separator . The default separator is a comma.
dt:lookup( string, lookupName, default)	Looks up a string in a lookup table. Specify the string to look up, the name of the lookup table, and a default value to return if the string does not exist in the table.
dt:min-lex( value1[, value2, ...])	Sorts the list of input parameters lexicographically and returns the first item in the sorted list. Each value can be: A simple value A variable that contains a list of strings A variable that contains a list of nodes where each node is a simple value.
dt:next-sequence()	Returns a node-set that contains the current element and all its following siblings, until another element of the same name.
dt:regex-match( string-to-match, regex)	Returns true if a string matches a regular expression.
dt:regex-replace( inputString, patternRegex, replacementString)	Returns inputString with all instances of patternRegex replaced by replacementString . If nothing matches patternRegex , the inputString value returns with no changes.
dt:string-replace( string1, string2, string3)	Replaces all instances of string2 in string1 with string3 .
dt:unadjusted-calculation-period-dates( startDate, endDate, timeUnit, timeUnitMultiplier, lookupDate, dateFormat)	Returns true if lookupDate is within the first specified time period in the specified range, where the time period is timeUnitMultiplier times timeUnit and the range is between startDate and endDate . timeUnitMultiplier is an integer. timeUnit is one of the following strings: Day or D Week or W Month or M Year or Y lookupDate is a date in the range between startDate and endDate . dateFormat defines the formats of lookupDate , startDate , and endDate