12/14/2015 - 12/23/2015
Completed
- KFS_F_LEDGER_ENTRIES loading logic change from full to incremental load.
- Loading time reduced from approx. 2hrs to <5mins.
- Source schema for the dev daily KFS refresh changed to KFSDAY2 to maintain scrubbed data.
- Informatica ETL to check for a valid current flag row in the KFS_D_FISCAL_PERIOD dimension completed.
- Informatica TEM_* tables staging loading mapping/session completed.
- 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-992 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-1001 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-1005 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-1008 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-1023 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-1030
- UCI_LD_CSF_TRACKER_SNAPSHOT missing data troubleshooting.
- Talend ETL logic miscalculation causing same period of the previous year to be deleted in addition to current year.
- Restored data from July 2015 database backup.
In Progress
- Informatica SRAQ.
Planned
- OR dimensional model design based on feedback from the functional teams.
- Developing an Informatica dev to prod deployment strategy that can be used as a standard across all teams.
11/30/2015 - 12/11/2015
Completed
- Troubleshooting deleted LDAP users in Informatica.
- Adjusted the LDAP sync schedule to once per day to avoid overhead on Informatica repository.
- Troubleshooting unexpected workflow restart after failed workflow recovery.
- Per Informatica support, the automatic restart is intended behavior and is caused by missed scheduled runs.
- Updated all current workflows to use the default parameter file location on the Informatica server.
- Developed additional workflow logic to check session statuses and email success notifications to all the nightly workflows.
- KFS_F_GL_BALANCE loading session config changes to use the truncate table table option instead of the Pre-SQL.
- Lunar daily staging/dim/fact refresh turned on for dss_kfs per the request of the report developers.
KFS
In Progress
- KFS_F_LEDGER_ENTRIES loading logic change from full to incremental load.
- Loading time should reduced significantly also making it easier for error recovery.
...