Icon

qa_​target_​ACT_​EMP_​ENTRIES

#Test Case: Existential Check (by Range):Description: Test to check continuity of date values and report missing dates in the Input table. #Test Case: REFERENTIAL INTEGRITY CHECK (Direct)#Input Data:TARGET.ACT_EMP_ENTRIES#Reference Data#Input Attribute/Column: EMPLOYEE_ID#Output Data: Dataset containing instances of the Input Attribute/Column that are NOT found in the Reference Data table.#Description: Ensure that the values in the EMPLOYEE_ID column matches those from the DIM_EMPLOYEE table. #Test Case: REFERENTIAL INTEGRITY CHECK (Parent/Child)#Input Data:TARGET.ACT_EMP_ENTRIES#Reference Data: DIM_FACILITY#Input Attribute/Column: P_FACILITY_NAME, HCL_FACILITY_F, HCL_FACILITY_L#Output Data: Dataset containing instances of the Input Attribute/Column that are NOT found in the Reference Data table.#Description: Records instances where P_FACILITY_CODE is not available for any given P_FACILITY_NAME. There are two such exception datasets created one each for HCL_FACILITY_F & HCL_FACILITY_L Node 120Node 123referene check with DIM_EMPLOYEEfor EMPLOYEE_IDNode 126Node 128Node 129Missing Dates CheckNode 131Node 132Node 133Node 134Node 135Node 136Node 137Node 138Node 139Node 140Node 141 DB Reader GroupBy ReferenceRow Filter DB Reader DB GroupBy DB Reader ReferenceRow Filter Create Date&TimeRange GroupBy Table Rowto Variable Date&Time-basedRow Filter DB Joiner DB Reader Rule-basedRow Filter DB GroupBy DB GroupBy DB Reader Rule-basedRow Filter #Test Case: Existential Check (by Range):Description: Test to check continuity of date values and report missing dates in the Input table. #Test Case: REFERENTIAL INTEGRITY CHECK (Direct)#Input Data:TARGET.ACT_EMP_ENTRIES#Reference Data#Input Attribute/Column: EMPLOYEE_ID#Output Data: Dataset containing instances of the Input Attribute/Column that are NOT found in the Reference Data table.#Description: Ensure that the values in the EMPLOYEE_ID column matches those from the DIM_EMPLOYEE table. #Test Case: REFERENTIAL INTEGRITY CHECK (Parent/Child)#Input Data:TARGET.ACT_EMP_ENTRIES#Reference Data: DIM_FACILITY#Input Attribute/Column: P_FACILITY_NAME, HCL_FACILITY_F, HCL_FACILITY_L#Output Data: Dataset containing instances of the Input Attribute/Column that are NOT found in the Reference Data table.#Description: Records instances where P_FACILITY_CODE is not available for any given P_FACILITY_NAME. There are two such exception datasets created one each for HCL_FACILITY_F & HCL_FACILITY_L Node 120Node 123referene check with DIM_EMPLOYEEfor EMPLOYEE_IDNode 126Node 128Node 129Missing Dates CheckNode 131Node 132Node 133Node 134Node 135Node 136Node 137Node 138Node 139Node 140Node 141DB Reader GroupBy ReferenceRow Filter DB Reader DB GroupBy DB Reader ReferenceRow Filter Create Date&TimeRange GroupBy Table Rowto Variable Date&Time-basedRow Filter DB Joiner DB Reader Rule-basedRow Filter DB GroupBy DB GroupBy DB Reader Rule-basedRow Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: parth
Created at: 2020-05-31
On NodePit since: 2021-08-31
Last update: 2024-04-28
Created with KNIME version: v4.0.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!