PowerExchange for PeopleSoft User Guide for PowerCenter

Back Next

Examples of Joining Effective Dated Records

The following examples show how the PowerCenter Integration Service joins effective dated records:

Extracting current rows with a join order

Extracting current rows without a join order

Joining effective dated records with a join order

Joining effective dated records without a join order

The examples do not include effective sequences.

Each example includes the following information:

The selected transformation options.

What the PowerCenter Integration Service does.

Results when you join two effective dated records.

The following table describes the examples you can use:

Term	Definition
Current Date	Date from which an effective date must be less than or equal to. When you specify a join order, the Extract Date is always the current date for the first table in the join order.
Effective Date	Value in the EFFDT column for a row of data.
Current Effective Date	Effective date that is the maximum date less than or equal to the current date.