Content Comparison

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

Completed section:

Completed the preliminary test of Informatica Asset fact job.  It failed because it loads way too many more records, inserts records every time the job runs without truncating the table.  The conversion team is working on fixing it.   Will need to continue test on this job as soon as they complete their fix.

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

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

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

Completed testing informatica jobs using queries from Manav.  They passed. 

Created a new tab "UCI Test By Queries" in the spreadsheet InformaticaJobsCompletionStatus_{today}.xlsx to test using queries.  I've found problems in their converted balance, gl entries fact jobs. I  sent them to the conversion team to fix. 

Created INC0029671 for Jeric from DBA to copy data from dss_kfs to dss schema.  Plan for informatica jobs to run on production to test.

Not complete yet section: 

(A Friendly reminder:  UCI off on Friday 7/3.  My vacation day or loose it on Thurs. 7/2) 

I haven't heard from middleware team about file triggers.  

Remaining fact jobs to verify: Need to add more tests on gl entries fact, AssetFact, AssetPaymentFact, Account dimension. 

Export all talend jobs on new server

ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT    

Anh’s Status 6/8/2015 – 6/19/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

...