JR34404: SLOWLY CHANGING DIMENSION (SCD) STAGE INSERTS NEW RECORDS WHEN NO UPDATES TO SOURCE DATA HAVE BEEN MADE.

APAR status

• Closed as program error.

Error description

• SCD stage creates new records when changes have not occured.
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Information Server 8.0.1 and higher users of the SCD stage.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Upstream operator partitioning was affecting the number of
  nodesupdatable lookup was being run on, causing lookups to be
       missed.  This resulted in records being sent down the
  insert   link of SCD when they should not have been.
  ****************************************************************
  RECOMMENDATION:
  Install patch JR34404
  This fix is included in 81 FP1
  ****************************************************************
  

Problem conclusion

• Updatable lookup will clear any preserve partitioning flags on
  its input data sets.  This will allow lookup to run on the
  number of nodes it should and not be constrained by other
  operators.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R802 PSN

     UP