Content Comparison

 Anh’s Status 7/6/2015 – 7/10/2015 (1 week status)

Completed section:

Completed adding stored procedure, latest sql files to https://services.adcom.uci.edu/jira/browse/KFSDW-590

Completed rescheduling on unix, deploy2 to run start running jobs on Sunday nights (was Monday nights) due to kfs running on Sunday.

https://services.adcom.uci.edu/jira/browse/KFSDW-800 

https://services.adcom.uci.edu/jira/browse/KFSDW-801

INC0031493 for Jeric to create oracle_prd linked server on solar.  This is completed.

Austin created new connection stage_kfs_infor on lunar, stage_kfs_infor_prod on solar.

Status on load_budget_fund_groups_fromExcel:  We told them not to convert.  It is not needed since Durendal built a front end for users.

https://services.adcom.uci.edu/jira/browse/KFSDW-804

Not Completed section:

Configure jobs to run by file triggers

Set up and configure connection to run informatica staging jobs on lunar to load oracle tables from production to stage_kfs_infor

set up and configure informatica dim, fact jobs to run on lunar to dss schema

set up and configure informatica dim, fact jobs to run on solar to dss_kfs schema

Continue working, debugging with Analytix team

Anh’s Status 6/822/2015 – 7/03/2015

...

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

...