Time-based Restart Points for CDC Sessions That Retrieve Data from the Logger
Time-based Restart Points for CDC Sessions That Retrieve Data from the Logger
If you use the PowerExchange Logger for Linux, UNIX, and Windows to log change data from a local or remote data source, you can optionally specify a date and time value as the restart point for PowerCenter CDC sessions that extract the change data from the Logger log files. Time-based restart points are source-specific.
A problem with this feature was found shortly before the PowerExchange 10.2 HotFix 1 release. A time-based restart of a PowerCenter CDC session might fail. Contact Informatica Global Customer Support to request the emergency bug fix (EBF) for this issue, which should be available soon. Alternatively, as a workaround, remove all CAPI_CONNECTION statements from the DBMOVER configuration file on the Integration Service machine where the PowerCenter CDC session runs. Make sure that no other PowerCenter tasks require these statements.
To set a time-based restart point, define a pair of explicit override statements in the restart token file, each with the same extraction map name to identify the source object. In one statement, specify the RESTART_TIME option. In the other statement, specify a date and time value. Use the following syntax:
extractionMapName
=RESTART_TIME
extractionMapName
=
datetime
Parameters:
extractionMapName
The name of an extraction map for the data source. To determine the extraction map name, use one of the following methods:
For CDC data map sources, see the
Schema Name Override
and
Map Name Override
attributes in the session properties. These attributes override the schema name and map name in the source extraction map. Or, in Designer, see the
Schema Name
and
Map Name
values in the source Metadata Extensions.
For relational sources, see the
Extraction Map Name
attribute in the session properties.
After the extraction map has been used to extract change data, the table name is appended to this value in the format
extractionMapName
_
tableName
. Use the full name when defining an explicit override statement.
RESTART_TIME
This option allows you to use a date and time value as the restart point for extraction processing in the Logger log files.
datetime
The date and time to use as the restart point in PowerExchange Logger for Linux, UNIX, and Windows log files. This value must be in the format YYYYMMDDhhmmssuuuuuu, where YYYY is a four-digit year, MM is the month, DD is the day of the month, hh is hours, mm is minutes, ss is seconds, and uuuuuu is microseconds.
For more information, see the "Extracting Change Data" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
or the "Configuring the Restart Token File" chapter in the