DICTIONARY 
  MODE=STATIC
  SOURCE=ONLINE
  [EXCEPTIONS={
FAIL|WARN}]
  ;

MODE

Required. Indicates whether PowerExchange Express CDC for Oracle expects the data dictionary to remain the same or change after reading it into memory. The only valid value is STATIC. In STATIC mode, PowerExchange expects the data dictionary to remain the same. If structural changes to source tables occur, the EXCEPTIONS parameter determines whether PowerExchange fails or issues a warning. However, PowerExchange Express CDC always tolerates the following DDL changes and continues CDC processing, regardless of the EXCEPTIONS setting:

ALTER TABLE ADD statements for adding one or more columns to a table
ALTER TABLE ADD PARTITION statements
ALTER TABLE ADD CONSTRAINT statements
CREATE USER statements
ALTER USER statements
DROP USER statements

SOURCE

Required. Indicates where PowerExchange Express CDC for Oracle gets its data dictionary information. The only valid value is ONLINE, which indicates that PowerExchange Express CDC for Oracle gets the data dictionary information from the Oracle online system when the change capture process initializes.

EXCEPTIONS

Optional. When MODE=STATIC, controls whether PowerExchange Express CDC for Oracle fails or continues with a warning message when it detects that a structural change was made to an Oracle table from which change data is captured.

This parameter does not apply to ADD PARTITION changes. PowerExchange Express CDC for Oracle tolerates ADD PARTITION changes.

Valid values are:

FAIL
. CDC processing ends abnormally with error message PWX-36355.
WARN
. PowerExchange prints the message PWX-36354, and CDC processing continues. This setting can result in loss of change data. Use this option only at the direction of Informatica Global Customer Support.

Default is FAIL.