Page Comparison

This wiki page will be used to document all of the work needed to test the KFS org hierarchy changes that will occur in September 2018.

Report Analysis

ETL Analysis

...

Plans

Database

We will use the dss_kfs test database to test the org changes on lunar

We will need to ask the dba team to create a new stage_kfs database (stage_kfs_test), copy stage_kfs to this new db

ETL

For incremental loads, the tables will need to be truncated on stage_kfs_test and ods_kbm schema

Need to verify that the table definitions on dss_kfs test match dss, update when necessary or drop/create

...

The KFS_UCP environment is refreshed from prod every Monday. Keiko manually runs a script to update the orgs after the environment is refreshed.

Austin Anh will manually change the source to KFS_UCP, and change the target to dss_kfs test and stage_kfs_test before running the workflows

KBM ETL Analysis

Reports/Packages

KFS Org Hierarchy Analysis

Create new Cognos folders for test packages and reports (Hidden Org Test)

Copy Cognos Packages, point them to dss_kfstest

Copy reports to point to new packages

...

Once reports are ready for deploy, they will be copied to the Hidden QA folder

Questions

...

How will we test the changes on MySQL and OLTP SQL Server (titania?)

 

JIRA Issues

...

Jira Legacy
server OIT System JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution maximumIssues 20 jqlQuery filter='UCPath Org Changes 2018' serverId 252346bdd1c6a489-c418217f-34af3ae9-94a0bd3a-0709b210881201dc24609c18