Icon

qa_​emp_​act_​info

staging.STG_ACT_INFODate_OccurredFirst_NameLast_NameEmployee_NumberCard_NumberEarliest_Access_TimeEarliest_Access_PointHCL_Facility_ELatest_Access_TimeLatest_Access_PointHCL_Facility_LWorkgroupsrcFilenameDatecreated target.ACT_EMP_ENTRIESTRANSACTION_DATE, EMPLOYEE_ID, FIRST_NAME, LAST_NAME, CARD_NUMBER, FIRST_ACCESS_TIME, FIRST_ACCESS_POINT, FACILITY_F, LAST_ACCESS_TIME, LAST_ACCESS_POINT, FACILITY_L, WORKGROUP staging.STG_ACT_INFO_ArchiveTRANSACTION_DATEEMPLOYEE_IDFIRST_NAMELAST_NAMECARD_NUMBERFIRST_ACCESS_TIMEFIRST_ACCESS_POINTFACILITY_FLAST_ACCESS_TIMELAST_ACCESS_POINTFACILITY_LWORKGROUPP_FACILITY_NAMEPROJECT_NAMECUSTOMER_NAMELAST_UPDATE_DATELOADED_BY INSERT INTO target.ACT_EMP_ENTRIES( TRANSACTION_DATE , EMPLOYEE_ID , FIRST_NAME , LAST_NAME , CARD_NUMBER , FIRST_ACCESS_TIME , FIRST_ACCESS_POINT , FACILITY_F , LAST_ACCESS_TIME , LAST_ACCESS_POINT , FACILITY_L , WORKGROUP , P_FACILITY_NAME , PROJECT_NAME , CUSTOMER_NAME , LAST_UPDATE_DATE , LOADED_BY )SELECT a.Date_Occurred , a.Employee_Number , a.First_Name , a.Last_Name , a.Card_Number , a.Earliest_Access_Time , a.Earliest_Access_Point , a.HCL_Facility_E , a.Latest_Access_Time , a.Latest_Access_Point , a.HCL_Facility_L , a.Workgroup ,g.Facility ,d.project_name ,d.Customer_Name , GETDATE(), 'AZURE DF'FROM staging.STG_ACT_INFO a left JOIN reports.map_Geo_Country_State_City_Facility g ON a.[HCL_Facility_E] = g.Facility LEFT JOIN [staging].[STG_FACILITY_EMPCUST] d ON a.Employee_number = d.Per_idwhere Workgroup IN ('HCL India','HCL VIP','HR') and a.Date_Occurred not in ( Select Distinct Date_Occurred from #Temp_Date ) Azure SQL instancestaging.STG_ACT_INFONode 76Node 77 Microsoft SQLServer Connector DB Table Selector STG_ACT_INFO STG_ACT_INFO_Archive staging.STG_ACT_INFODate_OccurredFirst_NameLast_NameEmployee_NumberCard_NumberEarliest_Access_TimeEarliest_Access_PointHCL_Facility_ELatest_Access_TimeLatest_Access_PointHCL_Facility_LWorkgroupsrcFilenameDatecreated target.ACT_EMP_ENTRIESTRANSACTION_DATE, EMPLOYEE_ID, FIRST_NAME, LAST_NAME, CARD_NUMBER, FIRST_ACCESS_TIME, FIRST_ACCESS_POINT, FACILITY_F, LAST_ACCESS_TIME, LAST_ACCESS_POINT, FACILITY_L, WORKGROUP staging.STG_ACT_INFO_ArchiveTRANSACTION_DATEEMPLOYEE_IDFIRST_NAMELAST_NAMECARD_NUMBERFIRST_ACCESS_TIMEFIRST_ACCESS_POINTFACILITY_FLAST_ACCESS_TIMELAST_ACCESS_POINTFACILITY_LWORKGROUPP_FACILITY_NAMEPROJECT_NAMECUSTOMER_NAMELAST_UPDATE_DATELOADED_BY INSERT INTO target.ACT_EMP_ENTRIES( TRANSACTION_DATE , EMPLOYEE_ID , FIRST_NAME , LAST_NAME , CARD_NUMBER , FIRST_ACCESS_TIME , FIRST_ACCESS_POINT , FACILITY_F , LAST_ACCESS_TIME , LAST_ACCESS_POINT , FACILITY_L , WORKGROUP , P_FACILITY_NAME , PROJECT_NAME , CUSTOMER_NAME , LAST_UPDATE_DATE , LOADED_BY )SELECT a.Date_Occurred , a.Employee_Number , a.First_Name , a.Last_Name , a.Card_Number , a.Earliest_Access_Time , a.Earliest_Access_Point , a.HCL_Facility_E , a.Latest_Access_Time , a.Latest_Access_Point , a.HCL_Facility_L , a.Workgroup ,g.Facility ,d.project_name ,d.Customer_Name , GETDATE(), 'AZURE DF'FROM staging.STG_ACT_INFO a left JOIN reports.map_Geo_Country_State_City_Facility g ON a.[HCL_Facility_E] = g.Facility LEFT JOIN [staging].[STG_FACILITY_EMPCUST] d ON a.Employee_number = d.Per_idwhere Workgroup IN ('HCL India','HCL VIP','HR') and a.Date_Occurred not in ( Select Distinct Date_Occurred from #Temp_Date ) Azure SQL instancestaging.STG_ACT_INFONode 76Node 77 Microsoft SQLServer Connector DB Table Selector STG_ACT_INFO STG_ACT_INFO_Archive

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