IDEV1 - Find Changes

Document created by nancy_kenney Employee on Dec 3, 2012Last modified by nancy_kenney Employee on Mar 23, 2016
Version 2Show Document
  • View in full screen mode
The Find Changes step provides a method for a process to track changes made to a document and send the document results down an Add, Update or Delete path. This is useful for processing large data sets or mainframe files where a full capture of the data always needs to be retrieved from the source system. An alternate process design should be considered if you can simply retrieve the modified data per process execution because it is naturally more efficient.

The Find Changes step parses one line at a time and forwards the result down the appropriate path.  In the following example our Find Changes step, shows we will be examining the data in a flat file called Org List FF.
0EM40000000PK8B


The Org List FF contains the following fields.
0EM40000000PK8L

We will be examining the following fields to determine if it is a new or existing record.
0EM40000000PK8a


The first execution of a process with this step will send all results down the Add path. Subsequent executions will use this first document as the basis for comparison, and added or updated data will be stored per execution.
0EM40000000PK8V

Attachments

    Outcomes