Content Comparison

Anh’s Status 9/1/2015 – 9/11/2015 (4 working days: 8th - 11th.  Off 4 vacation days and Labor Day)

Regarding "Investigated with Analytix the 3 ods jobs that failed all of a sudden", they edited these jobs, dropped prefix DB schema on tables.  I fixed them.  They've been running fine since. 

Fixed the informatica CAFP job because Analytix had wrong column name.  It now runs fine.

Completed and verified month end outbound loads Informatica CFSBAL, CAFP, and SMS workflows for September below:

[dss].[ods_kfs].[UCI_UCOP_CFSBAL_RCRD_10_T]

[dss].[ods_kfs].[UCI_UCOP_CFSBAL_RCRD_11_T]

[dss].[ods_kfs].[UCI_UCOP_CFSBAL_RCRD_20_T]

[dss].[ods_kfs].[UCI_UCOP_CFSBAL_RCRD_30_T]

[dss].[ods_kfs].[UCI_UCOP_CFSBAL_RCRD_31_T]

[dss].[ods_kfs].[UCI_UCOP_CAFP_ACCOUNT_T] 

[dss].[ods_kfs].[UCI_UCOP_CAFP_FUND_T]

[dss].[ods_kfs].[UCI_SMS_FEED_SUMMARY_T]

[dss].[ods_kfs].[UCI_SMS_FEED_DETAIL_T]

Created queries to give Bryce to verify balance 1 job using account number and worked with Analytix on balance 1 job.  Test passed.  No mismatch.

Created a new variable and configured informatica dimensions, facts workflows so that they can be scheduled to run nightly on the test production to stage_kfs_infor to avoid colliding with the Talend jobs. 

Did trouble-shoot the failed tests that Bryce reported on the dim jobs: account, doc type, project, object code, chart.  Need to configure them to run in synched with Talend then retest them.

Anh’s Status 8/17/2015 – 8/28/2015   

Worked with the DBA, Middle Ware teams on INC0037523 INC0037600.  They now completed, closed.

...

Investigated with Analytix the 3 ods jobs that failed all of a sudden today after they ran every night without any issue for the last couple weeks.  We should hear from them soon.

Anh’s Status 7/27/2015 – 7/31/2015 (1 week status)

...

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

...