Anh’s Status 6/822/2015 – 7/03/2015
...
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 Completed INC0029671 for : Jeric from DBA to copy data from dss_kfs to dss schema. Plan for informatica jobs to run on production to test.
Created 13 new jiras (KFSDW-771 throught 783). Per our conversation, I’ve assigned most to Bryce, to myself the most difficult ones (balance, gl entries facts)to assign to Bryce to verify informatica jobs by comparing data between Talend and Informatica tables.
Worked with conversion team to debug their jobs: They used wrong type as real instead of decimal(19,2) for amount columns.
Reopened jira for Jeric to create the sql link server on solar for production https://services.adcom.uci.edu/jira/browse/DWH-1604. He finished.
INC0030044 Jeric to fix problem not able to see oracle tables in oracle _dev linked server on nebula.
Added more amount columns to balance, gl entries fact table to test. Sent problems found to Conversion team.
Cleaned up talenddev01 server to gain up to 7GB of disk space. It was full, unable the Conversion team to perform their debugging.
wf_staging_cg has error running. Reported to Conversion team.
Created tables KFS_D_DOC_FISCAL_PERIOD, KFS_D_PROJECT and their primary keys for talend and informatica schemas to get ready for sqldiff tool to run.
Not complete yet section:
(A Friendly reminder: UCI off on Friday 7/3. My vacation day or loose it on Thurs. 7/2)
...
Remaining fact jobs to verify: Need to add more tests on gl entries fact, AssetFact, AssetPaymentFact, Account dimension.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
1) Completed fixing staging krns job
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
2) Pager duty this week.
3) Completed
. Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-671
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.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
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 Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-656
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:
with the newest revision to the re-mapping logic: When I came back from my 1-day vacation (due to many accumulated vacation hours, use it or loose it), I was told that we hold off on this task until further direction. Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-486
6) Pager duty next week.
Anh’s Status 3/16/2015 – 3/27/2015
...