Source Search Specification

Source Sort Specification

Defines the source Buscomp search spec and sort spec. The value can be a literal search spec or sort spec string. It can also contain a named parameter. See Using Named Parameters in DTU. For example:

[Id] = [&ContactId]

where ContactId is a named parameter. At run time, only named parameters are replaced by their string values.

Source Record Row Number

One can selectively transfer only a subset of source Buscomp records. This can be defined in three formats:

• Start-End
• Start-
• Number

For example, 0-5, 4-, 0.

NOTE:  The row number starts at 0.

Operation Override

This option allows one to override the operation at the component level. For example, if the current operation is Insert, you can use this option to set some component to operate Update instead.

No Association

Y or N. Applicable to buscomps that have association list. By default, it is Y. Data Transfer Utilities first try to locate the desired destination record in the associate list. If successful, the located record is associated. Otherwise, a new record is created.

If N, association of existing records is not attempted. A new record is created instead.

Cached Updates

The valid values include:

• Source Component
• Destination Component
• Source or Destination Component

This is a performance enhancement option that defers sending SQL statements to the database until they can be sent together. Since none of the SQL statements is sent until the end, subsequent steps in the block cannot be dependant on a previous step having been committed to the database.

When you turn on this option, make sure to confirm all SQL statements are generated correctly and there is no inter-dependency.

Field Validation

Y or N. By default it is Y.

By default, setting field values in a Siebel BusComp triggers field value validation. If you have a bounded picklist, the new value is validated against the picklist and the fields in the pick maps are set. Disabling field validation also turns off picklists. It is a performance enhancement option.

Source Filter Specification

An expression in Siebel search specification syntax that is used to filter out records at the runtime. Only source records whose filter specification evaluates to be true are transferred.

Filter specification differs from search specification in that search specification is imposed at the database query, and filter specification is imposed while looping through the records.

Disable Order Management Signals

The valid values include

• Source Component
• Destination Component
• Source or Destination Components

When the Disable Order Management Signals option is imposed on the source or destination components, buscomp operations on those buscomps do not trigger order management signals during the data transfer process.