PowerExchange Interfaces for PowerCenter

10.5.1
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring Lookups for CDC Data

Lookup transformations can be used in mappings extracting data from CDC sources including tables to which the CDC data is being applied.

If you use dynamic lookups for CDC data and sharing the lookup cache with other static lookups in the same mapping, specify both of the following custom properties in the session Custom Properties attribute field on the Config Object tab:

MergeCDCReaders=Yes

SingleThreadExecutionModel=Yes

These custom properties remove any partition points from the PWXPC CDC Reader through the transformations to the Writer. As a result, the order of the changes read from the change stream is maintained until the changes reach the Writer. This then ensures that any CDC data placed into a dynamic lookup cache is accessible to lookups sharing that cache in other pipelines.

The use of these custom properties will impact session throughput as it will single-thread all source data from the Reader through to the Writer. As a result, these custom properties should only be specified when there is a need to share CDC data stored in a dynamic cache across pipeline.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Configuring Lookups for CDC Data

Configuring Lookups for CDC Data