8/11 - 8/24
ETL:
Met with Kevin to gather detail information/logic on the remaining requirement: To create CG_ORG_GRP_KEY and CG_ORG_GRP_SID: Concat string using criteria of FIN_COA_CD,ORG_CD,CGPRPSL_NBR, CGAWD_PRM_ORG_IND from the CG_AWD_ORG_T table in the CG_ORG_GRP table. Then in the KFS_D_CG_AWD table, create the key using the same criteria to create a key, then use this key to look up in the CG_ORG_GRP table to get the value of the CG_ORG_GRP_SID (integer).
Completed adding null handling for KFS_D_CG_AGNCY, 100+ columns in the KFS_D_CG_AWD table.
Completed KFS_CG_ORG_GRP, KFS_D_CGAWD_BDGTPER. They’re ready for test.
Informatica admin task:
Completed, closed tickets below:
Misc.:
Meeting with Kevin from Accounting on remaining requirements of the Award task
Attended Weekly KFS Decision Support Meeting
Attended Weekly KFS Decision Support Technical Status
Next plan:
Continue with the Award task
KFS upgrade related activities
Informatica admin related activities
7/28 - 8/10
ETL:
Completed adding etl rule to handle nulls to most columns in the award dim table. Kevin said he'll notify me which ones he wants to handle nulls. I'll need to revisit it when he has details. This task is 90% complete. I’m waiting for the remaining requirement that have the source tables, fields as dummy such as PRMRY_ADDR_ST_NM, ALTRNT_ADDR_ST_NM.
Per Durendal’s request, I attended his meeting that he scheduled us to debug, solve problem with his mapping.
Misc.:
Supported INC0182648.
Attended Weekly KFS Decision Support Meeting
Attended Weekly KFS Decision Support Technical Status
Next plan:
Continue with the Award task
KFS upgrade related activities
Informatica admin related activities
...
Closed the following jiras:
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1550
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1549
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1579
UAT:
Test failed, reported to Analytix to fix the following jiras:
...
Continue
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
UATs
Continue with this activity.
1/3 - 1/12
ETL
Completed, verified SBS, Outbound month-end.
Completed https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx). Unit test is in progress.
UATs:
Following jiras are completed, ready for deploy:
(KFS_F_TEM_ACCTNG)Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1443
(KFS_F_DSBRMNT_VCHR)Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1436
Training
...
Complete testing to be ready for deploy https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx).
As soon as migration completes on the production informatica server and to prepare for the next month-end, I need to work with Jarrod to verify, test the following jiras to ensure that his aps send triggers to the appropriate locations:
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1550
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1549
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1579
UATs
Continue with this activities.