Page Comparison

Anh’s Status 10/01/2015 – 10/29/2015

•       Worked with the DBA team to investigate kfs daily jobs failed this week.   The cause of the failure was that the backup of our databases collided with our nightly jobs.  DBA team  
  rescheduled it at a different time.  The problem was solved.  Daily jobs have been running fine. 
•      Verified, fixed to add value 2 for precision to all amounts in the fact columns.
•      Worked with BI team to investigate, fixed mismatches between Talend and Informatica that they found in the kfs informatica ods, dimension and fact.   Several amount columns were incorrect in both versions such as gl_income_amt due to missing fiscal period joins.  They were fixed, ready to roll out.
•      ODS:  Solved mismatches, identified the sources for missing tables in Informatica.  They will need to be created before roll out.
•      Dimension:  Mismatches were fixed, verified.  These jobs are ready to be rolled out to production this w/e.
•      Fact:  Mismatches were fixed, verified.   Verified, fixed to add value 2 for precision to all amounts.  It's ready to be rolled out this w/e.
•      All verify queries and their results were recorded in the status sheet in folder \\abs.uci.edu\dfs\adcom\shares\docs\SystemDev\KUALI Project\D-1 Data Warehouse\ETL\UCI
•      Created jiras to turn over Informatica dimension, fact to production. 
•      Wrote plan to roll out in JIRA  https://services.adcom.uci.edu/jira/browse/KFSDW-898
•      Coordinated with Web Service and our teams to run their outbound jobs for month-end next month while I'll be in Mexico attending my niece's wedding.  My 6-day vacation will be 11/3 - 11/10.
• Supervised Bryce with verifying Informatica data using recently creating queries including the ones to calculate gl balance amounts to test.   He completed, closed his jiras.

Plan on Friday 11/29 - Saturday 11/30 for roll out Informatica dimension, fact jobs to production: 

Friday:  Setup, verify connections to production DB.  Unplug Talend dimension, fact jobs.

Saturday: Jobs run, verify results, debug, fix if necessary.

Anh’s Status 9/14/2015 – 9/25/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

...