Manually adding a Source Department to MDClone hierarchies

Requirements

CPA Example

Validation:
Source Department
Description:
Verifies that all the values from datalakedb_new.ev_transfers and column source_department exist in mdc_app_hierarchies.mdc_hierarchy_level_item_6 (hierarchy 'Department_Hierarchy_PROD | 273')
Failure Summary:
1 values from the Master Table Impala.`datalakedb_new`.`ev_transfers`.`source_department` do not exist in the Lookup table `mdc_app_hierarchies`.`mdc_hierarchy_level_item_6`
Example:
List of the values that were not found: CH NW SCC LAB SPEC - 9
 
this will need to be added manually to MDClone

Steps

1. Log into MDClone application

2. Navigate to Data Content Settings --> Categorization Management

3. Find Categorization listed in CPA error Description (Example above: Department_Hierarchy_PROD)

4. Left click on the operation selector at the right side of Categorization and select "Settings"