Versions Compared

Version Old Version 28 New Version 29
Changes made by

Kim Anh Thi Le

Oluwasemilore Ajibola (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Repair Jira Macros

11/17 - 12/14

...

    • Completed the last bridge table of the Award model.  The jira https://jira.oit.uci.edu/browse/KFSDW-1671 is ready for test. 
      Update:  Kevin said to me to wait for him when I can go ahead to replicate all ETL objects relating to award model in the KFS7.
    • Jira Legacy
      serverOIT System JIRA
      serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
      keyKFSDW-1728
       Completed ETL and testing.  I'm waiting for Pramod when I can deploy it in the upgrade environment.
    • Jira Legacy
      serverOIT System JIRA
      serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
      keyKFSDW-1727
      Completed ETL for the followings:
      • m_ods_kbm_postInfo_Load_YTD_FTE
    • m_ods_kbm_postInfo_Load_Current_FTE
    • m_ods_kbm_postInfo_Load_Current_FTE_2
    • m_ods_kbm_postInfo_Load_Final_Bal_FTE
    • m_ods_kbm_postInfo_Load_LDGR_ONLY_T
    • m_ods_kbm_postInfo_Load_LD_Ldgr_Bal _V02_T
      The lead testers approved to deploy them (CHG0033273).  Tomorrow these will be deployed to production by Austin, to upgrade by me.

    • Started https://jira.oit.uci.edu/browse/KFSDW-1732. 

...

Next plan:

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1167

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1707

Continue with the Award task

...

8/25 - 9/7 (campus closed on Labor Day on the 4th)

ETL:

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1702
 Completed ETL.  It's now ready for test.

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1668

Fixed CGAWD_ENTRY_DT.  This data is now available.

Fixed ETL for ucinetids.  This data is now available.  Regarding the multiple project director ucinetids, Kevin said that he'll get back to me on my questions to confirm on requirements for getting this data.   

 

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1290
  Completed ETL.   It’s now ready for test 

...

Next plan:

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1167

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1707

Continue with the Award task

...

    • Had meeting with Jarrod to gather requirements for the ledger and balance from kfsstage for the PI task,  https://jira.oit.uci.edu/browse/KFSDW-1638.
    • Coordinated with Austin to replace dwhreader account with ppsoper so that ledger, balance data for PI can be loaded to dwhs_ppscurr database.
    • Completed setting up a new ODBC on PC for Informatica client to connect to dwhs_ppscurr.
    • Created new mappings, sessions for this task.  Completed ETL development for loading them to sqlserver in the dwhs_ppscurr. 
    • Helped Alvin per his request to verify ledger PI data coming from his java app.  We confirmed that data is correct as expected.
    • Completed configuring a control timer (to wait for ledger completes loading in oracle kfsstg database) in Daily_OLTP to schedule to load ledger PI data nightly starting tonight.
    • Attended weekly DSS meeting where I reminded that I'm waiting for Kevin to finish testing  
      Jira Legacy
      serverOIT System JIRA
      serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
      keyKFSDW-1496
       in order to migrate it to production. 
      Today I was told that he's not ready for it yet.
    • Attended weekly one-1-one status meeting.

...

  • ETL: Continue with balance PI for 
    Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-1638
     
  • Informatica Admin related activities

...

  • Completed putting in changes for https://jira.oit.uci.edu/browse/KFSDW-1604.  It's now ready for test by users.
  • Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-1496
      Today Pramod confirmed that the changes I put in in the mapping in my personal folder look good.  I'm going ahead to continue to migrate the changes to the real table in the balance fact table for users to test.
  • Completed 4 days intensive training in Informatica ETL level 1 & 2.
  • Jira Legacy
    serverOIT System JIRA
    serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
    keyKFSDW-1626
     Because the Informatica server was restarted on (March 4) during the jobs currently ran and before the triggers arrive (March 7, 10) to run these jobs to load, the Informatica scheduler updated to April;  Therefore these jobs were scheduled to run in April, didn't run when the triggers arrived in March.  I was told that there's no other way for the Informatica scheduler to reset to current month schedule after it was restarted.  The solution:  I manually restart the jobs. Results:  all data for this month-end is available.  

...

Missing mappings in

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1458
,
Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1459
.  Today's status meeting with Analytix, they said that they'll provide the mappings then we can test.

...

2/10 - 2/23

ETL

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1496
:   Per Valerie’s suggestion, I sent details, changes I made to the balance fact ETL to Pramod for his confirmation.  I’m waiting for his confirmation.

...

https://jira.oit.uci.edu/browse/KFSDW-1604

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1496

KFS related upgrade activities

...

Closed the following jiras:  

 

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1550

         

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1549

         

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1579

UAT:

Test failed, reported to Analytix to fix the following jiras:

...

Continue

Jira Legacy
serverOIT System JIRA
serverId252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18
keyKFSDW-1496
  

  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:

         

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1443
 (KFS_F_TEM_ACCTNG)

         

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1436
 (KFS_F_DSBRMNT_VCHR)

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
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1550

         

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1549

         

Jira Legacy
server
OIT
System JIRA
serverId
252346bd
d1c6a489-
c418
217f-
34af
3ae9-
94a0
bd3a-
0709b2108812
01dc24609c18
keyKFSDW-1579

  UATs

     Continue with this activities.