Operations Guide

10.2 HotFix 1
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2
- 10.1 HotFix 1
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

System Definition

Data will be loaded from a Flat-File containing XML messages. Define an IDT in the User-Source-Tables section of the SDF for each IO.

All field names must correspond to the names of the fields in the IO. Any fields present in the IO but not listed in the IDT definition will be ignored.

Field types must be W (wide format) as the XML messages contain Unicode. Field lengths are specified in bytes, not Unicode characters.

If synchronization is required, the

sync_clause

should specify

SYNC REPLACE_DUPLICATE_PK TXN-SOURCE NSA

, otherwise

NOSYNC

Specify the Siebel

RowId

as the primary key (

The Logical-File-Definition describing the flat file must specify

FORMAT=XML

and

VIEW=<IDTName>1

(the IDT name suffixed by "1" which is the automatically generated view name).

The Loader-Definition must specify

OPTIONS=FIXED

The Controls parameter of the

IDX-Definition

and

Search-Definition

associated with the IDT must specify

UNICODE-ENCODING=6

(for MSQ) and

UNICODE-ENCODING=8

(for ORW).

For example,


Section: User-Source-Tables
*
CREATE_IDT
						Contact
SOURCED_FROM FLAT_FILE
			Alias         W(32),
			BirthDate     W(20),
			FirstName     W(32),
			LastName      W(32),
			MiddleName    W(32),
			City          W(32),
			Country       W(32),
			PostalCode    W(10),
			StreetAddress W(100),
(PK)     RowId         W(16)

SYNC REPLACE_DUPLICATE_PK
TXN-SOURCE NSA
;

Rename Saved Search

Table of Contents

Operations Guide

Operations Guide

System Definition

System Definition