Page Comparison

6/12 - 6/15 

ETL:

On my first day back from vacation, I was asked to fix daily_oltp failure on dev.   Completed.  It has been running nightly without any issue.

Misc.:

Worked with the DBA team to complete  INC0171185

Attended 1-on-1 weekly status meeting

Attended KFS upgrade and Award dimension meeting

 Next plan:

Work on recently assigned task for the award etl https://jira.oit.uci.edu/browse/KFSDW-1656

KFS upgrade related activities

Informatica admin related activities

5/19 - 6/1

ETL:

• Completed kfsdw-1646.  The staging LD_LDGR_ENTR_T table has been loading incrementally nightly on dev as expected without any issue with data.  Per Austin, we don’t need to make any changes to ods because it loads from staging.  Per Austin’s plan to deploy, this task will be migrated some time later after the first week of June.
• Completed kfsdw-1638.  Both tables LD_LDGR_ENTR_PI_T, LD_LDGR_BAL_PI_T have been loading incrementally nightly on dev as expected without any isuue with data.
• Completed validating all dependencies of the LD_LDGR_ENTR_T without any error:

...

Closed the following jiras:  

UAT:

Test failed, reported to Analytix to fix the following jiras:

...

Continue

  UATs

     Continue with this activity.

1/3 - 1/12

ETL

     Completed, verified SBS, Outbound month-end.

     Completed https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496  (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx).  Unit test is in progress.

UATs:

     Following jiras are completed, ready for deploy:

Training

...

     Complete testing to be ready for deploy https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx). 

     As soon as migration completes on the production informatica server and to prepare for the next month-end, I need to work with Jarrod to verify, test the following jiras to ensure that his aps send triggers to the appropriate locations:

  UATs

     Continue with this activities.