Icon

qa_​emp_​facility_​details

Test case #1: Integrity check for Employee ID Test case #2: Integrity check for Parent Facility Code Test case #3: Parent Child Facility Mapping Test case #4: Facility master sanity checks staging.STG_FACILITY_EMPCUSTNode 158Node 161target.DIM_EMPLOYEENode 163Node 164Exception table for missing or duplicate employeestarget.PARENT_CHILD_MAPNode 167Node 168Exception table for Child FACILITY with NO Parent Facilitytarget.DIM_FACILITYNode 171Node 172Exception table for Parent Facility with Facility dimensionNode 174Exception table for duplicate Parent facilitiesNode 176target.DIM_LOCATION DB Reader GroupBy Joiner DB Reader Rule-basedRow Filter Joiner Rule-basedRow Filter DB Reader GroupBy Joiner Rule-basedRow Filter DB Reader GroupBy Joiner Rule-basedRow Filter GroupBy Joiner Rule-basedRow Filter DB Reader Test case #1: Integrity check for Employee ID Test case #2: Integrity check for Parent Facility Code Test case #3: Parent Child Facility Mapping Test case #4: Facility master sanity checks staging.STG_FACILITY_EMPCUSTNode 158Node 161target.DIM_EMPLOYEENode 163Node 164Exception table for missing or duplicate employeestarget.PARENT_CHILD_MAPNode 167Node 168Exception table for Child FACILITY with NO Parent Facilitytarget.DIM_FACILITYNode 171Node 172Exception table for Parent Facility with Facility dimensionNode 174Exception table for duplicate Parent facilitiesNode 176target.DIM_LOCATION DB Reader GroupBy Joiner DB Reader Rule-basedRow Filter Joiner Rule-basedRow Filter DB Reader GroupBy Joiner Rule-basedRow Filter DB Reader GroupBy Joiner Rule-basedRow Filter GroupBy Joiner Rule-basedRow Filter DB Reader

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-05-02
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!