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.
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/16/2015 - 11/25/2015
Completed
...