Page Comparison

Anh's Status 11/18 - 12/11

ETL

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1537  (Load CG_AGENCY_ADDR_T to dwhs_ods db on nebula/nova):  This task was completed, verified and was migrated to production.

...

1442 KFS_F_TEM_EXPENSE:  passed test.   It’s ready for deploy.

Next plan:

ETL

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1550 (Migrate the Informatica SBS aging to production server)

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1549 (SBS aging data files to the Informatica production server)

...

ETL

INC0125556, INC0126590, https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1532 (Need to enhance the SBS Aging task to avoid duplicate records):  Completed.

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1537 Completed  ETL development. 

...

1449 (KFS_D_SPCL_CRCMSTNCS) Passed. Ready to deploy

Next plan:

ETL

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1537 plan to start testing as soon as the Informatica DB connection is provided for kfstst2 where requester placed test data.

...

Anh's Status 10/21 - 11/3

ETL

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1290:  Completed loading new rafg data for October per user’s request

INC0125556, INC0126590, https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1532 (Need to enhance the SBS Aging task to avoid duplicate records):  Completed the development of this task.  The final testing phase is in progress.

...

• Complete and migrate to production https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1532 (Need to enhance the SBS Aging task to avoid duplicate records)
• https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1537 (Load CG_AGENCY_ADDR_T to dwhs_ods db on nebula/nova once the table is installed in KFS)
  work on this as soon as CG_AGENCY_ADDR_T is in KFS per jira https://jirauci.oitatlassian.uci.edunet/browse/KFSI-13803.
• https://jirauci.oitatlassian.uci.edunet/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx)

...

Today we received Analytix’s responses and fixes after I emailed the list of jiras to them.  We now can continue with UATs. 

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1416: Completed and ready to deploy

...

Below are the remaining jiras that both Analytix and we are waiting for resolution when Pramod comes back from his vacation:

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1361

Not able to continue with uat due to column DOC_NBR_ID  not exists in the ETL Rule:  If PDP_PMT_DTL_T.FDOC_TYP_CD =  PREQ, CM, or DVCA then get corresponding CUST_PMT_DOC_NBR and lookup with KS_D_DOC_HDR.DOC_NBR_ID and get SID.

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1362: KFS_F_DSBRMNT_ITM_ACCTNG.  Invalid object name 'D_DATE'.".  Both etl developer, uat tester need Pramod’s solution on this.

...

https://services.adcom.uci.edu/jira/browse/KFSDW-1418 waiting for Analytix's unit test query

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1361 KFS_F_DSBRMNT_ITM: BadRecCount = 2 and JoinedRecCount = 3 for the first test query (dss_kfs.KFS_D_DSBRMNT_UCI_BNK).  Analytix is investigating.

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1362 KFS_F_DSBRMNT_ITM_ACCTNG: Encountered “Error converting data type nvarchar to numeric”.  Informed Analytix to investigate

https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-1394 KFS_F_PREQ_ITM: missing the name of the wf/session, unit test query.  Analytix said to provide soon.

...

• Month-end outbound jobs: Per Jarrod’s request, I monitored the triggers, jobs run, verified monthend data for sms feed, BUD100, STF100, STF200, CAFP, CFSBAL
• Regarding Oracle server move on the week end 6/11:  Per user’s request to load data asap, I modified Informatica ods jobs to configure production connections to load Loading_GL, PDP_PMT_GRP_T, ods_kfs.GL_ENTRY_T, ods_kfs.PDP_PMT_GRP_T tables on production.   After loading I put back the development connection.  Talend ods jobs continued to load after changing to the new Oracle connection.
• https://services.adcom.uci.edu/jira/browse/KFSDW-1290.  This jira is ready to be deployed.  Provided details to deploy in jira https://services.adcom.uci.edu/jira/browse/KFSDW-1338
• Completed planning in excel sheet for all DW passwords needing change including proposed dates in the wiki page  in the section 10 item b. at: https://wikiuci.oit.uci.eduatlassian.net/wiki/pages/viewpage.action?pageId=84970735668025573.
  After sending the page out to the key stakeholders to confirm proposed schedules, they confirmed, I updated.  Completed the final draft.  It’s ready to email to everyone.

...

1) Completed fixing staging krns job

2) Pager duty this week. 

3)  Completed

     Completed setting up to schedule this job to run nightly.

4)  Emailed ddls scripts to Analytix per their request to create tables below:

...

6)  Need to schedule syncInvoiceNumberSundryDebtors to run on production

Anh’s Status 3/28/2015 – 4/10/2015

...

1)  Fixed uciSmsGIFeed.  ods_kfs.UCI_SMS_FEED_DETAIL_T table now has all records for Feb. data with batch date ’06-MAR-15’, matching Oracle side:  31,647 records, debit amount total is $3,647,165,482.52. 

...

5)  Analytix:  Provided our versions of our DBs that they asked.  They confirmed access to talenddev server.  Attended weekly status meeting this Friday morning.  They're going to send me a list of sqlsver tables so I can send them DDLs to them to create these tables.

6)  uciSmsGIFeed:  The job loaded month-end data this month without problem.  FYI -  Following day, this was the 2nd time this month that Jarrod reran, regenerated the trigger.  The job ran fine 2nd time. 

7)  Completed

• Not complete yet section: 

  1)  Staging krns job loaded all tables but Talend sent false notification.  I need to debug this job.
  2)  Export all talend jobs on new server
  3)  ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT

...

5)  SBSO: 

6) Pager duty next week. 

Anh’s Status 3/16/2015 – 3/27/2015

...