9/12/2016 - 9/23/2016
Completed
- Annual password changes for Informatica connections
- PO data mart Informatica mappings and sessions
- Merging Analytix development back to the main Daily_* workflows.
- Audited/corrected slew of issues related to objects not following proper dev standards, unconnected ports, unconfigured session options, and other misc. issues mentioned on numerous occasions.
- Informatica on-site training proposals discussions.
- Received quotes from 3 vendors - Informatica University, LearnQuest, and ExistBI.
- Fixed invalid date values in KC.
- In-depth discussion on VM cluster performance degradation.
- Assisting Jane troubleshoot her Informatica development for UC Path.
- 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-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-1493 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-1495 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-1487
In Progress
- KC Negotiations module dimensions/fact ETL design.
- Zena Agent install on etl-dev.
- Stalled installation due to firewall issues.
- 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/29/2016 - 9/9/2016
Completed
...