Icon

qa_​employee_​details

Employees: India => STL is null & country = 'India'' DQ_SEGMENT FLG_EXISTS_PARENT_IN_MAP FLG_PARENT_EMP_EQ_MAP FLG_EXISTS_PARENT_IN_DIM Count(EMPLOYEE_ID) OK 1 1 1 119321NOT IN MAP 0 0 1 503NOT IN DIM 1 1 0 43609DIFF EMP VS MAP 1 0 0 8NO INFO 0 0 0 44 Fetch columns from Staging: - STL- facility_name- CWL_* PARENT FACILITY INFOFROM MAPPING TABLE PARENT FACILITY INFOFROM DIM FACILITY TABLE Facility Code # NA 16 53007714 2 5168846751785780516448565185869251794294518588725185796351646359 Azure SQL instancetarget.DIM_EMPLOYEEEmployee ID IS NOT NULLTARGET.DIM_FACILITYstaging.STG_FACILITY_EMPCUSTEmployee ID IS NOT NULLNode 143Node 146Node 150TARGET.FACILITY_MAPNode 153Node 154Node 155Node 157Create a flagforsame parent code in employee& Mapping tableNode 159Node 160Create a flagforExistence check in Mapping tableCreate a flagforExistence check in dimension tableNode 165Create DQ segmentation variablebased on flagsVisualize by segmentsURL:http://localhost/dq_dim_employee.htmlNode 168Classify Location typeinto Client loc, WFH & Othersacross India & GlobalNode 170Node 171162726Node 173Node 175 Microsoft SQLServer Connector DB Table Selector DB Row Filter DB Table Selector DB Table Selector DB Reader DB Row Filter DB Joiner DB GroupBy DB Reader DB Table Selector DB Reader Joiner Column Rename Joiner Rule Engine Column Rename GroupBy Rule Engine Rule Engine GroupBy Rule Engine Python Script (1⇒1) Column Filter Rule Engine GroupBy GroupBy DB Reader DB GroupBy DB Reader Joiner Employees: India => STL is null & country = 'India'' DQ_SEGMENT FLG_EXISTS_PARENT_IN_MAP FLG_PARENT_EMP_EQ_MAP FLG_EXISTS_PARENT_IN_DIM Count(EMPLOYEE_ID) OK 1 1 1 119321NOT IN MAP 0 0 1 503NOT IN DIM 1 1 0 43609DIFF EMP VS MAP 1 0 0 8NO INFO 0 0 0 44 Fetch columns from Staging: - STL- facility_name- CWL_* PARENT FACILITY INFOFROM MAPPING TABLE PARENT FACILITY INFOFROM DIM FACILITY TABLE Facility Code # NA 16 53007714 2 5168846751785780516448565185869251794294518588725185796351646359 Azure SQL instancetarget.DIM_EMPLOYEEEmployee ID IS NOT NULLTARGET.DIM_FACILITYstaging.STG_FACILITY_EMPCUSTEmployee ID IS NOT NULLNode 143Node 146Node 150TARGET.FACILITY_MAPNode 153Node 154Node 155Node 157Create a flagforsame parent code in employee& Mapping tableNode 159Node 160Create a flagforExistence check in Mapping tableCreate a flagforExistence check in dimension tableNode 165Create DQ segmentation variablebased on flagsVisualize by segmentsURL:http://localhost/dq_dim_employee.htmlNode 168Classify Location typeinto Client loc, WFH & Othersacross India & GlobalNode 170Node 171162726Node 173Node 175 Microsoft SQLServer Connector DB Table Selector DB Row Filter DB Table Selector DB Table Selector DB Reader DB Row Filter DB Joiner DB GroupBy DB Reader DB Table Selector DB Reader Joiner Column Rename Joiner Rule Engine Column Rename GroupBy Rule Engine Rule Engine GroupBy Rule Engine Python Script (1⇒1) Column Filter Rule Engine GroupBy GroupBy DB Reader DB GroupBy DB Reader Joiner

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