Preface
XML Concepts
Using XML with PowerCenter
Working with XML Sources
Using the XML Editor
Working with XML Targets
XML Source Qualifier Transformation
Midstream XML Transformations
XML Datatype Reference
- XML and Transformation Datatypes
  - XML Date Format
XPath Query Functions Reference
- XPath Query Functions Overview
- Function Quick Reference
- boolean
- ceiling
- concat
- contains
- false
- floor
- lang
- normalize-space
- not
- number
- round
- starts-with
- string
- string-length
- substring
- substring-after
- substring-before
- translate
- true

XML Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Creating Metadata from Flat Files

You can create an XML definition by importing a flat file definition from the repository. If you import more than one flat file definition, the Designer creates an XML definition with a view for each flat file. The views have no relationship to each other in the XML definition. If you choose to create a root view, the Designer creates the views with foreign keys to the root.

The following figure shows a sample XML source definition from flat files orders and products: