Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Flagging the Current Value

Flagging the Current Value

The Integration Service generates a current flag of 1 for each row written to the target. This flag indicates the dimension is new or newly updated. If the row is an update to an existing dimension, the Integration Service resets the existing dimension current flag to 0.
As a result, all current versions of a dimension appear in the target with a current flag of 1. All previous versions have a current flag of 0.
For example, the following dimension data is current because the current flag is set to 1:
ITEM
STYLES
PM_CURRENT_FLAG
Sandal
5
1
Boot
25
1
When these dimensions change, the Integration Service inserts the updated versions with the current flag of 1. The Integration Service also updates the existing rows in the target. It finds the previous current version (where the current flag is set to 1 and updates the current flag to 0:
ITEM
STYLES
PM_CURRENT_FLAG
Sandal
5
0
Boot
25
0
Sandal
12
1
Boot
15
1


Updated June 25, 2018