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
7/14 - 7/27
ETL:
KFS_D_CG_AWD: kfsdw-1656
Completed coding, unit test for multiple directors group. Unit test passed.
Completed coding, unit test for CG_ORG_GRP_SID. Unit test failed due to incorrect type as bigint for strings in the table and requirement. Waiting to get fixed in order to re unit test to complete this jira.
KFS_D_CG_AGNCY: kfsdw-1669
Completed coding, unit test most of the columns. Test passed. There are two columns that need requirement (currently source tables, fields are "dummy"). Waiting for their requirements in order to complete. I emailed to appropriate team members to address this missing requirement.
Bridge tables (KFS_CG_ORG_GRP,KFS_CG_ORG_GRPMBR, KFS_D_CGAWD_BDGTPER)
I was told that our completed bridge tables for other projects, they don't have insert, update transformations, insert and update dates. I noticed that these bridge tables that were created, have all these dates. Please confirm if they need them or need to be removed from the table.
Misc.:
Attended 1-on-1 weekly status meeting
Attended KFS Upgrade for Decision Support meeting
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.