DI-037 Data Integration - Initial Load The initial load shall record the date and A log entry for the initial load exists. (of JIS Data) time of the initial load Data Integration - Initial Load The initial load shall use the same The same transformations for the initial DI-038 (of JIS Data) transformations created to support load is also used by subsequent updates. continued updates. DI-039 Data Integration - Court Post migration, if it is determined that The JIS Database and the EDR are back to Migration the migration was not successful, the the state prior to migration AOC Migration database shall be used to re-insert previously purged records. DI-040 Data Integration - Transformations shall only pull data Transformations use the date and time Transformation that has been added or updated since the recorded in the log from the previous pull. last transformation execution Data Integration - Transformations shall record the start The start time is recorded in the DI-041 Transformation time of the transformation transformation log DI-042 Data Integration - Transformations shall log current status A review of the log throughout the Transformation of execution (i.e. started, loading, execution of the transformations show complete with no exceptions, complete what operations have completed and which with exceptions, etc.) ones are currently running. DI-043 Data Integration - Staging The staging area must be able to Records deleted at the source are present in identify deleted records and retain for the corresponding ZDEL table. possible re-insertion.
DI-037 Data Integration - Initial Load (of JIS Data) The initial load shall record the date and time of the initial load A log entry for the initial load exists. DI-038 Data Integration - Initial Load (of JIS Data) The initial load shall use the same transformations created to support continued updates. The same transformations for the initial load is also used by subsequent updates. DI-039 Data Integration - Court Migration Post migration, if it is determined that the migration was not successful, the AOC Migration database shall be used to re-insert previously purged records. The JIS Database and the EDR are back to the state prior to migration DI-040 Data Integration - Transformation Transformations shall only pull data that has been added or updated since the last transformation execution Transformations use the date and time recorded in the log from the previous pull. DI-041 Data Integration - Transformation Transformations shall record the start time of the transformation The start time is recorded in the transformation log DI-042 Data Integration - Transformation Transformations shall log current status of execution (i.e. started, loading, complete with no exceptions, complete with exceptions, etc.) A review of the log throughout the execution of the transformations show what operations have completed and which ones are currently running. DI-043 Data Integration - Staging The staging area must be able to identify deleted records and retain for possible re-insertion. Records deleted at the source are present in the corresponding ZDEL table.
EXHIBIT%20K%20-%20EDR%20Data%20Integration%20HL%20Design.docx