XML Guide

10.4.0
- 10.5

Back Next

Setting XML View Options

By default, the Integration Service generates rows for each view that has data in the view row. To change how the Integration Service generates rows for some XML source definition views, select XML View Options in the XML Columns window.

Use the following methods to determine when the Integration Service generates rows from an XML source:

Generate all the foreign keys in a view.
By default, the Integration Service generates values for one foreign key in a view. If a view has more than one foreign key, the other foreign keys have null values. You can generate values for all the foreign keys.

Stop recursive reads in a circular relationship
. By default, the Integration Service generates rows for all occurrences of data in a circular relationship. You can generate a row for just the first occurrence of recursive data.

Generate a row for a child view if a parent exists.
By default, the Integration Service creates rows for all views with data in the view row. You can generate a row for a child view only when a parent view has data.

Generate a row for a view without view row data.
By default, the Integration Service generates data for a view when the view row has data. You can generate a row for a view that has no data in the view row.

Generate rows for specific complex types in a type relationship.
By default, the Integration Service generates rows for all views in the XML definition. You can generate rows for specific views in type relationships.

Using the XML Editor

Generating All Hierarchy Foreign Keys

Generating Rows in Circular Relationships

Generating Hierarchy Relationship Rows

Setting the Force Row Option

Generating Rows for Views in Type Relationships

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal