User Guide

10.2.3
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Example 2: Using Nested Shared Values to Correct XML Parsing

Informatica Managed File Transfer is designed to read very large XML documents in the fastest and most efficient way possible. For complex XML files, nested attribute values can cause a Project to create unexpected results in your output.

For example, the following Department XML elements contain two attributes; name and code.

<EmployeeData>
<Department name=”Infosec” code=”BB001”>
<Department name=”HR” code=”F02A1”>
<Department name=”Drafting” code=”BC940”>
</EmployeeData>

When you create the ReadXML task, you wish for the Department code values to appear before the Department name values. Your two column elements are defined as:

Index 1 - /EmployeeData/Department/@code
Index 2 - /EmployeeData/Department/@name

When you execute the Project, you expect your output to appear like this:

BB001 | Infosec
F02A1 | HR
BC940 | Drafting

Instead, the actual output is pairing the department names to the wrong department codes:

BB001|InfoSec
F02A1|InfoSec
F02A1|HR
BC940|HR
BC940|Drafting

Rename Saved Search

Table of Contents

User Guide

User Guide

Example 2: Using Nested Shared Values to Correct XML Parsing

Example 2: Using Nested Shared Values to Correct XML Parsing