Page Comparison

11/3 - 11/16

ETL:   

• • Completed the last bridge table of the Award model.  The jira https://jira.oit.uci.edu/browse/KFSDW-1671 is ready for test. 
    Update:  Kevin said to me to wait for him when I can go ahead to replicate all ETL objects relating to award model in the KFS7.

  • Jira Legacy
    server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1728

     Completed ETL and testing.  I'm waiting for Pramod when I can deploy it in the upgrade environment.

  • Jira Legacy
    server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1727

    Completed ETL for the followings:
    
    • m_ods_kbm_postInfo_Load_YTD_FTE
  • m_ods_kbm_postInfo_Load_Current_FTE
  • m_ods_kbm_postInfo_Load_Current_FTE_2
  • m_ods_kbm_postInfo_Load_Final_Bal_FTE
  • m_ods_kbm_postInfo_Load_LDGR_ONLY_T
  • m_ods_kbm_postInfo_Load_LD_Ldgr_Bal _V02_T
    The lead testers approved to deploy them (CHG0033273).  Tomorrow these will be deployed to production by Austin, to upgrade by me.
    
    
  • Started https://jira.oit.uci.edu/browse/KFSDW-1732. 

Misc.:

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/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:

...

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.