Table of Contents

Search

  1. Preface
  2. Configuring PowerExchange for PeopleSoft
  3. Understanding PowerExchange for PeopleSoft
  4. Working with PeopleSoft Sources
  5. Application Source Qualifier for PeopleSoft Sources
  6. Accessing XLATTABLE Data
  7. Creating PeopleSoft Sessions and Workflows
  8. Datatype Reference
  9. PeopleSoft Language Codes
  10. Glossary

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Handling EFFSEQ when Extracting Current Rows

Handling EFFSEQ when Extracting Current Rows

Some effective dated PeopleSoft records include effective sequence columns. The effective sequence column, EFFSEQ, is used when multiple rows become effective on the same date. When you extract current rows from the effective dated records, the PowerCenter Integration Service selects the row with the most recent date in the effective sequence.

0 COMMENTS

We’d like to hear from you!