Page Comparison

11/17 - 12/14

ETL:   

• KFSDW-1728 Completed and verified.  It’s ready for test.  Completed CHG0033310 to deploy from kfs7 to dev, production.  Before my work on this ETL enhancement, it took more than 1 hour to load the ledger fact table nightly.  After I completed the ETL,  it now only takes about 10 minutes to load incrementally.
• kfsdw-1727:Completed deploying changes, to KFS7.  Completed verifying. Completed CHG0033312
• kfsdw-1732:  Completed using variables for stage DB connection in the code for all KBM ETL.  Migrated these objects to KFS7. 
• https://jira.oit.uci.edu/browse/KFSDSU-252  Completed verifying with cognos developers.  They confirmed that their reports show accurate data.
• The Daily_oltp night job sometimes failed on dev due to the conflict schedule in KFS7.  This affected the web services apps.  The problem was solved by moving schedule at a later time in KFS7.  I worked with web services developers to ensure they accessed data ok now.  I also suggested that they deploy their apps to production where data there has been available.  I was told that they did.

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

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. 

...

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.