What would cause virtually every terminated user's record to be updated on each import even though no changes were made in the source data, and how to correct?

Problem details:

Upon every user import, over 26K users are reported as having been updated. However, the source data show that all but a few ere unchanged; Similarly, pre-import comparison with post-import users table finds no changes for except to uniquecode and updatedate.

Review of the records with only the uniquecode and updatedate modified finds that all of them have a status of 0; in addition, all users with status of 0 except for one are being impacted.

Our user import does not populate either uniquecode nor updatedate. The import is configured with a post-processor to populate the manager information, but only where the updatedate field was updated to today. It also is configured with a status description rule for lifecycle change detection.

asked 12 Mar '15, 17:48

JasonBlue's gravatar image

accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 12 Mar '15, 17:48

Seen: 1,051 times

Last updated: 12 Mar '15, 17:48