8/29/2016 - 9/9/2016
Completed
- KC Negotiations module dimensional model design completed.
- KC Negotiations module staging ETL completed.
- Testing difference session configurations to optimize session read/write performance.
- KFS balance fact table incremental load strategy review.
- 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-1472 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 - CTASK0012584
In Progress
- 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.
- Troubleshooting ETL performance issues from etl0 to solar.
- Write bottleneck suspected from the session logs on solar.
- Data Center team has moved the solar server vm to same physical host as lunar.
- DBA team suspect an abundance of CPUs causing cxpacket waits and will add 2 additional CPUs to lunar to confirm slowness.
Planned
- Informatica SRAQ.
- Need to schedule meetings with security team.
8/15/2016 - 8/26/2016
Completed
...