Transforming Data Using the XQuery Mapper

XQuery Mapper Overview

Data Transformation

BEA XQuery Mapper

What Happened to DTF Files?

Transforming Data Using XQuery

Launching the XQuery Mapper

XQuery Mapper Sample Project

Creating a New XQuery Mapper Project

Creating and Importing Schema Files

Importing XML Schemas

Creating XML Schema Files Using XML Schema Editor

Creating WSDL Files Using WSDL Editor

Importing MFL Schemas

Selecting Source and Target Data Types to Generate XQuery

Using the Design View to Create Data Transformations

Creating Basic Element Transformations

Creating Basic Attribute Transformations

Creating Complex Map Transformations

Editing Map Transformations

Viewing and Editing Generated XQuery Files

Using the Constraints Tab

Using the Target Expression Tab

Using the Target Expression Tab to Edit XQuery Code of a Link

Using the Target Expression Tab to Add If-Then-Else Constructs to a Link

Inserting Calls to XQuery Functions

Invoking XQuery Functions in a Query

Using Expression Variables

Using the Property Editor When Editing an XQuery file

Testing Map Transformations

XQuery Mapper Testing Functionality Overview

Validating During Design Time

Understanding Design View Graphical Representations

Link Menu Options

Understanding Map Representations

Understanding Map Transformation Links

XML Global Elements, Global Types, Local Elements, and Attributes

Examples: Manipulating and Constraining Data Using XQuery

Combining Data From Different Schemas

Mapping Repeating Elements and Creating a Join

Step 1. Create a New XQuery File

Step 2. Add a Conditional Constraint

Step 3. Add Links to Populate Empty Element

Step 4. Calculate Total Cost

Step 5. Add a Constraint With Multiple Conditions

Using the Union Option of the Constraints Tab

Creating a Transformation Between a Repeating Source and Non-Repeating Target

Creating a Transformation Between a Non-Repeating Source and Repeating Target

Creating a Nested If-Then-Else Expression

Step 1. Create New XQuery Transformation

Step 2. Create First If Condition

Step 3. Create First Nested If-Then-Else Condition

Step 4. Create Second Nested If-Then-Else Condition

Using Recursive Schemas

Creating Group By Key Fields XQuery Constructs

Testing XQuery Files