Page Comparison

10/20 - 11/2

ETL: 

• Completed the last bridge table of the Award model.  The jira https://jira.oit.uci.edu/browse/KFSDW-1671 is ready for test.
• Worked with appropriate team members and discussed solution to solve the problem with the LD_LDGR_ENTR_T missing records in the KFS7 due to entry_ID not being generated in sequence from the application side.  We're waiting for the application developer (Jarrod) to fix his logic then we'll reload it. 
• For the KFS upgrade activities,  attended discussion meetings to gather requirements to load the fact table kfs_f_ledger_t in the KFS7 environment.  Created a new JIRA to start working on it:  https://jira.oit.uci.edu/browse/KFSDW-1728.
• To replicate all ETL objects relating to award model in the KFS7, I've created jiras to work on this task.   They're below:

https://jira.oit.uci.edu/browse/KFSDW-1720

https://jira.oit.uci.edu/browse/KFSDW-1721

https://jira.oit.uci.edu/browse/KFSDW-1722

https://jira.oit.uci.edu/browse/KFSDW-1723

https://jira.oit.uci.edu/browse/KFSDW-1724  

Misc.:

Completed the draft version of Achieve.  Plan to complete the final version then submit it ASAP.

Attended 1-on-1 weekly status meeting

Weekly KFS Decision Support Technical Status

Attended KFS Upgrade for Decision Support meeting

Next plan: 

On-going ETL development to maintain and upgrade KFS DW

On-going KFS upgrade related activities

Informatica admin related activities

10/6 - 10/19

ETL: 

Completed, closed https://jira.oit.uci.edu/browse/KFSDW-1713

...

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.