5/9/2016 - 5/20/2016
Completed
- Adjusted KC ODS Informatica mappings to add additional logic to account for KC proposal workflow change.
- New logic based on pre and post 10/21/2015 cutoff dates.
- Proposal quarterly average trends Cognos report.
- SPA reports specification review/discussion with OR functional staff (on-going).
- Source of RPT_DEPT_CODE changes in the awards over fiscal years identified and documented.
- KFS_D_FISCAL_PERIOD delayed row active indicator review.
- Powershell scripts execution issue in Informatica successfully resolved.
- ODS table inventory list completed to reduce confusion in the Informatica ODS conversion.
- Web services annual password change update for Informatica workflows completed.
- Informatica code reviews:
- PUR_VNDR_SUPP_DVRST_T
- KFS_D_BLDG_ROOM_LOAD
In Progress
- KC ODS report specifications documentation write-up.
- KFS production database server migration prep work and configuration changes
- Firewall rules for connectivity to ODAPRD.
- DSNs/Infa connection objects need to be setup.
- Currently awaiting KFSPRD refresh on ODAPRD. Will test to KFSSTG until refresh is complete.
- Informatica SRAQ.
- Need to schedule meetings with security team.
- On-going Informatica training sessions for Jane Gao.
Planned
- Zena working session with Michael Story for automation of workflow failures (Currently waiting to meet with Michael Story).
- Defining relationships for all SPA system tables for the Cognos framework model (Currently waiting for documentation from Eric).
4/25/2016 - 5/6/2016
Completed
...