8/15/2016 - 8/26/2016
Completed
- KC Negotiations module review for dimensional model design.
- Resolved firewall issues from Cognos app servers to the KFS ODAs.
- D_DATE dimension table schema moved to edw.
- Annual password change for prod reader accounts.
- JIRAs 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-1452 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-1453 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-1408 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-1253
- Production deployments 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-1461 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-1058
In Progress
- Troubleshooting ETL performance issues from etl0 to solar.
- Write bottleneck suspected from the session logs on solar.
- Testing difference session configurations to optimize session read/write performance.
- KFS balance fact table incremental load strategy review.
- KC negotiations ETL staging workflow.
Planned
- Informatica SRAQ.
- Need to schedule meetings with security team.
- Zena working session with Michael Story for automation of workflow failures (Currently waiting to meet with Michael Story).
8/1/2016 - 8/12/2016
Completed
...