9/26/2016 - 10/7/2016
Completed
- KC Negotiations module dimensions/fact ETL design
- Discussion with Michael Story regarding implementation of Zena Informatica scheduling.
- Informatica app server configuration changed to allow for batch scripting for scheduling.
- Currently waiting for de-allocation of existing Zena client license.
- Script for command prompt workflow execution sent to Michael.
- Informatica overview presentation slides for brown bag session.
- JIRA issues completed:
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1467 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1478 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1497 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1511
In Progress
- Troubleshooting/fixing new development by Analytix for KFS data mart additions.
- PO
- Disbursement
- Sponsor category code reconciliation for SPA reports.
- KC Negotiations module dimensional model Cognos Framework design.
- Sample Cognos reports design as POC for OR functional staff.
- Informatica PowerExchange for LDAP price quote request and purchase justification.
- UCI staff holiday list compilation for update to the date dimension.
- Zena Agent install on etl-dev.
- Waiting on firewall exceptions to be completed by the security team.
- Troubleshooting ETL performance issues from etl0 to solar.
- Incremental fact table loading deployed to alleviate performance issues.
- Continuing to encounter semaphore timeouts from Solar.
Planned
- Informatica SRAQ.
- Need to schedule meetings with security team.
9/12/2016 - 9/23/2016
Completed
...