MaxTransactionNumber Property

The MaxTransactionNumber property sets or returns the maximum number of records that Transformer processes before committing the changes to a cube.

Syntax

Application .MaxTransactionNumber

Applies To

Application Object

Discussion

Use this property to determine when Transformer inserts checkpoints at various stages as it generates cubes. This setting limits the number of records held in temporary status before inserting a checkpoint. Should an error prevent the completion of a cube, you can restart the process at the last committed checkpoint.

A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation.

Default: 500,000.

Type

Long

Access

Read/Write

Examples

objTransApp.MaxTransactionNumber = 500000