Icon

IMAS_​Migration-HR-50

CLEAN POSKOD

CLEAN DATE

CLEAN MARITAL_STATUS

CLEAN PHONE

EMPMAS

BANKCODE

SKIMMAS

POSTDESC-

JAWATAN

POSTMAS

POSTHISTORY

POSTMARA

HIS

POSTMARA

URUSAN

SCALESSM_D

SCALESSM_M

KELAYAKAN

EDUMAS

WARIS

TANGGUH

ELAUN

ELNMAS

DEDMAS

DEDUCTION

DEDACCNT

NOTAX

Q_LEVEL

UNIVERSITY

SIJILTECH

IKTISAS_M

AHLI_IKTISAS

BINTANG

PREVPOST

OLDPOST

DEPENDENTS

SPOUSE

BINTANG_M

NEWSCALE_M

NEWSCALE_D

JAWATAN

POSTDESC

Export InvalidQ_LEVEL Records
Excel Writer
Filter Invalid Q_LEVEL
Rule-based Row Filter
Select CleanQ_LEVEL Columns
Column Filter
Filter ValidQ_LEVEL
Rule-based Row Filter
Read F Q_LEVEL
DB Reader
RenameQ_LEVEL for F
Column Renamer
Truncate F Q_LEVEL
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Table F Q_LEVEL
DB Table Selector
UNIVERSITY
DB Table Selector
Insert F Q_LEVEL
DB Writer
Convert UNIVERSITYNumber to Integer
Double to Integer
Raw UNIVERSITY
DB Reader
Clean UNI_KOD
String Manipulation
Convert UNIVERSITYInteger to String
Number to String
Clean UNI_DESC
String Manipulation
Clean UNI_ABBR
String Manipulation
Validate UNIVERSITY
Rule Engine
DuplicateUNI_KOD Check
GroupBy
StatisticUNIVERSITY Status
GroupBy
Export duplicate
Excel Writer
FilterDuplicateUNI_KOD
Rule-based Row Filter
Export InvalidUNIVERSITY Records
Excel Writer
Filter InvalidUNIVERSITY
Rule-based Row Filter
Select CleanUNIVERSITY Columns
Column Filter
Filter ValidUNIVERSITY
Rule-based Row Filter
RenameUNIVERSITY for F
Column Renamer
Generate MIG-12 NEWSCALE_D Issue Register
DB Query Reader
Summarise MIG-12 NEWSCALE_D Issues
GroupBy
newscale_m
Excel Writer
NEWSCALE_M Post-Migration Summary
DB Query Reader
NEWSCALE_D Post-Migration Summary
DB Query Reader
Report MIG-12 NEWSCALE_D Non-Mapped Fields
DB Query Reader
newscale_d
Excel Writer
newscale_d
Excel Writer
newscale_m
Excel Writer
CLEANED DB
Microsoft SQL Server Connector
Table F UNIVERSITY
DB Table Selector
Read F UNIVERSITY
DB Reader
Truncate F UNIVERSITY
DB SQL Executor
Insert F UNIVERSITY
DB Writer
Validation lookupKELAYAKAN
DB Query Reader
Missing Reference
DB Query Reader
Raw SIJILTECH
DB Reader
Uni missing ReferenceKelayakan
Excel Writer
Report MIG-12 NEWSCALE_M Non-Mapped Fields
DB Query Reader
newscale_m
Excel Writer
Generate MIG-12 NEWSCALE_M Issue Register
DB Query Reader
Summarise MIG-12 NEWSCALE_M Issues
GroupBy
SIJILTECH
DB Table Selector
Convert SIJILTECHInteger to String
Number to String
Convert SIJILTECHNumber to Integer
Double to Integer
Clean SIJIL_DESC
String Manipulation
Clean SIJIL_TECH
String Manipulation
StatisticSIJILTECH Status
GroupBy
Validate SIJILTECH
Rule Engine
Filter DuplicateSIJIL_TECH
Rule-based Row Filter
DuplicateSIJIL_TECH Check
GroupBy
Export duplicate
Excel Writer
Generate MIG-13 Issue Register
DB SQL Executor
Read MIG-13 Issue Detail
DB Query Reader
Profile MIG-13 SCALESSM_M Staging Status
DB Query Reader
Profile MIG-13 Lookup Readiness
DB Query Reader
Summarise MIG-13 Issues
DB Query Reader
Report MIG-13 Non-Mapped Source Fields
DB Query Reader
Excel Writer
Validate No MIG-13Blocking Issues
DB SQL Executor
Migrate SCALESSM_M to PO_POSITION_SALARY_SCALE_SSPAS
DB SQL Executor
Excel Writer
Excel Writer
Export InvalidSIJILTECH Records
Excel Writer
Filter InvalidSIJILTECH
Rule-based Row Filter
Select CleanSIJILTECH Columns
Column Filter
Filter ValidSIJILTECH
Rule-based Row Filter
Read NORMALIZED_HRref_post_master
DB Reader
Table FSIJILTECH
DB Table Selector
LookupPOSTHISTORYPost Master
Joiner
RenameSIJILTECH for F
Column Renamer
StatusPOSTHISTORYPost Lookup
Rule Engine
CLEANED DB
Microsoft SQL Server Connector
Tableref_post_master
DB Table Selector
Truncate F SIJILTECH
DB SQL Executor
Truncatestaff_position_history
DB SQL Executor
Insert FSIJILTECH
DB Writer
Selectstaff_position_historyColumns
Column Filter
Read FSIJILTECH
DB Reader
Tablestaff_position_history
DB Table Selector
Read NORMALIZED_HRstaff_position_history
DB Reader
Raw POSTMARA
DB Reader
Insertstaff_position_history
DB Writer
Inspect MIG-13 SCALESSM_M Mapping Values
DB Query Reader
50: DBHR_POPP
Microsoft SQL Server Connector
newscale_d
Excel Writer
Profile MIG-13 SCALESSM_M Source
DB Query Reader
Profile MIG-13 SSPA Target Lookups
DB Query Reader
Build MIG-13 SCALESSM_M Source
DB Query Reader
50: DBHR_POPP
Microsoft SQL Server Connector
Load MIG-13 SCALESSM_M Staging
DB Writer
Validate MIG-13 SCALESSM_M Staging Load
DB SQL Executor
IKTISAS_M
DB Table Selector
Prepare MIG-13 SCALESSM_M Staging
DB SQL Executor
Select MIG-13 SCALESSM_M Staging Columns
Column Filter
Clean IKTISAS_CD
String Manipulation
Raw IKTISAS_M
DB Reader
POSTMARA
DB Table Selector
CleanIKTISAS_ABBRV
String Manipulation
CleanIKTISAS_DESC
String Manipulation
ConvertPOSTMARAInteger to String
Number to String
StatisticIKTISAS_M Status
GroupBy
ConvertPOSTMARANumber to Integer
Double to Integer
ValidateIKTISAS_M
Rule Engine
Clean PM_SCALE
String Manipulation
FilterDuplicateIKTISAS_CD
Rule-based Row Filter
CleanPOSTMARANumeric StringColumns
String Manipulation (Multi Column)
DuplicateCheckIKTISAS_CD
GroupBy
Clean PM_STATUS
String Manipulation
Clean PM_SKIMX
String Manipulation
Export duplicate
Excel Writer
Clean FLEKSI_GRED
String Manipulation
Clean FLEKSI_YN
String Manipulation
Clean PM_FILLER
String Manipulation
StatusFLEKSI_DATE
Rule Engine
StatusPM_CRET_DATE
Rule Engine
renamePM_CRET_DATE_PARSED
Column Renamer
ParsePM_CRET_DATE
String to Date&Time
renameFLEKSI_DATE_PARSED
Column Renamer
ParseFLEKSI_DATE
String to Date&Time
PreparePM_CRET_DATEParse Value
Rule Engine
ValidatePOSTMARA
Rule Engine
PrepareFLEKSI_DATEParse Value
Rule Engine
MIG-13 Post-Migration Summary
DB Query Reader
Excel Writer
StatisticPOSTMARA Status
GroupBy
StatisticFLEKSI_YN
GroupBy
StatisticPM_STATUS
GroupBy
FilterDuplicatePOST_NUM
Rule-based Row Filter
StatisticDuplicatePOST_NUM
GroupBy
Select CleanPOSTMARA Columns
Column Filter
Filter ValidPOSTMARA
Rule-based Row Filter
Truncate F POSTMARA
DB SQL Executor
Rename POSTMARAfor F
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
50: CLEANED DB
Microsoft SQL Server Connector
50: IMAS.DBHR_POPP
Microsoft SQL Server Connector
50: CLEANED DB
Microsoft SQL Server Connector
50: CLEANED DB
Microsoft SQL Server Connector
GroupBy
50: IMAS.DBHR_POPP
Microsoft SQL Server Connector
Table F POSTMARA
DB Table Selector
Insert F POSTMARA
DB Writer
Select POSTMARANormalized Columns
Column Filter
Read F POSTMARA
DB Reader
CreatePOSTMARAsource_key
String Manipulation
Rename POSTMARAfor NORMALIZED
Column Renamer
NORMALIZED DB
Microsoft SQL Server Connector
Tableref_post_master
DB Table Selector
ref_post_masterlookup columns
Column Filter
Readref_post_master
DB Reader
Check POSTMARAvsref_post_master
Joiner
Finalref_post_maraColumns
Column Filter
Status POSTMARAPost Master Lookup
Rule Engine
Insertref_post_mara
DB Writer
Truncateref_post_mara
DB SQL Executor
Filter MissingPOSTMARA Post Master
Rule-based Row Filter
StatisticPOSTMARA Lookup
GroupBy
Export MissingPOSTMARAPost Master
Excel Writer
MissingPOSTMARAPost Master Summary
GroupBy
ConvertHISPOSTMARAInteger to String
Number to String
DB Table Selector
Excel Writer
50: CLEAN DB
Microsoft SQL Server Connector
Excel Writer
50: CLEAN DB
Microsoft SQL Server Connector
DB Reader
Extract Table Dimension
50: SHORTLIST
Microsoft SQL Server Connector
Excel Writer
HISPOSTMARA
DB Table Selector
Excel Writer
ConvertHISPOSTMARANumber to Integer
Double to Integer
Extract Table Dimension
Raw HISPOSTMARA
DB Reader
CleanHISPOSTMARANumeric StringColumns
String Manipulation (Multi Column)
StatusPM_START_DATE
Rule Engine
Clean PM_SCALE
String Manipulation
PreparePM_START_DATEParse Value
Rule Engine
StatusPM_END_DATE
Rule Engine
ParsePM_START_DATE
String to Date&Time
PreparePM_END_DATEParse Value
Rule Engine
Extract Table Dimension
String Manipulation
50: CLEANED DB
Microsoft SQL Server Connector
String Manipulation
Excel Writer
Excel Writer
Extract Table Dimension
rename columnPM_START_DATE_PARSE
Column Renamer
Excel Writer
Excel Writer
rename columnPM_END_DATE_PARSE
Column Renamer
50: Clean DB
Microsoft SQL Server Connector
ParsePM_END_DATE
String to Date&Time
Extract Table Dimension
StatisticHISPOSTMARAStatus
GroupBy
ValidateHISPOSTMARA
Rule Engine
Filter ValidHISPOSTMARA
Rule-based Row Filter
StatisticHISPOSTMARAPM_SCALE
GroupBy
RenameHISPOSTMARAfor F
Column Renamer
Select CleanHISPOSTMARAColumns
Column Filter
CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Extract Table Dimension
Excel Writer
50: CLEAN DB
Microsoft SQL Server Connector
Excel Writer
Insert F HISPOSTMARA
DB Writer
DB Table Selector
Truncate F HISPOSTMARA
DB SQL Executor
DB Reader
Read F HISPOSTMARA
DB Reader
Extract Table Dimension
Table F HISPOSTMARA
DB Table Selector
Excel Writer
Create HISPOSTMARASource Key
String Manipulation
RenameHISPOSTMARAfor NORMALIZED
Column Renamer
Tablestaff_master
DB Table Selector
LookupHISPOSTMARAStaff Master
Joiner
NORMALIZED DB
Microsoft SQL Server Connector
Excel Writer
Readstaff_master
DB Reader
Extract Table Dimension
Excel Writer
Extract Table Dimension
Excel Writer
DB Table Selector
StatusHISPOSTMARAStaff Lookup
Rule Engine
50: CLEAN DB
Microsoft SQL Server Connector
DB Query Reader
Readref_post_master
DB Reader
Excel Writer
LookupHISPOSTMARAPost Master
Joiner
Extract Table Dimension
StatusHISPOSTMARAPost Master Lookup
Rule Engine
DB Reader
Tableref_post_master
DB Table Selector
50: SHORTLIST
Microsoft SQL Server Connector
Tableref_position_description
DB Table Selector
LookupHISPOSTMARAPosition Description
Joiner
StatusHISPOSTMARAPosition Lookup
Rule Engine
Readref_position_description
DB Reader
FinalHISPOSTMARANormalized Columns
Column Filter
Excel Writer
Excel Writer
Extract Table Dimension
FilterInValid POSTMAS
Rule-based Row Filter
Excel Writer
Excel Writer
Extract Table Dimension
Excel Writer
Excel Writer
Excel Writer
Extract Table Dimension
Excel Writer
Extract Table Dimension
50: Clean DB
Microsoft SQL Server Connector
Excel Writer
Extract Table Dimension
create table F JAWATAN
DB SQL Executor
50: Clean DB
Microsoft SQL Server Connector
Excel Writer
Excel Writer
Extract Table Dimension
Handle MissingPOSTDESC StringColumns
Missing Value
Clean POSTDESCNumeric Strings
String Manipulation (Multi Column)
Convert POSTDESCNumber to Integer
Double to Integer
Convert POSTDESCInteger to String
Number to String
Clean POST_DESC
String Manipulation
CLEANED DB
Microsoft SQL Server Connector
create correction load table
DB SQL Executor
Raw POSTDESC
DB Reader
POSTDESC
DB Table Selector
38: SHORTLIST
Microsoft SQL Server Connector
Update Audit IMAS Result - JAWATAN
DB SQL Executor
Create IMAS mig staging
DB SQL Executor
Read READYJAWATAN Staff Services
DB Query Reader
Insert IMASPP_STAFF_SERVICES
DB Writer
Microsoft SQL ServerConnector IMAS_HRMS
Microsoft SQL Server Connector
create table F POSTDESC
DB SQL Executor
Check IssueLog - JAWATAN
DB Query Reader
Check ColumnMapping LogJAWATAN
DB Query Reader
Insert ColumnMappingLog - JAWATAN
DB SQL Executor
Check AuditLog - JAWATAN
DB Query Reader
DB Table Selector
Insert F POSTDESC
DB Writer
Read F POSTDESCfor IMAS
DB Query Reader
Create POSTDESCSource Key
String Manipulation
Select POSTDESCF Columns
Column Filter
Add POSTDESCF Metadata
Constant Value Column Appender
Truncate F POSTDESC
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Column Renamer
Rename POSTDESC for F
Column Renamer
Filter POSTDESCF Issues
Rule-based Row Filter
Export POSTDESCF Issues
Excel Writer
Validate POSTDESCF Layer
Rule Engine
Filter ValidPOSTDESC For F
Rule-based Row Filter
Status POST_CODE
Rule Engine
Status POST_DESC
Rule Engine
Mark POST_CODEDuplicate Status
Rule Engine
Join POSTDESCDuplicate Status
Joiner
Status KOD_JPA
Rule Engine
CountPOST_CODE Duplicate
GroupBy
GroupBy
50: CLEANED DB
Microsoft SQL Server Connector
Check F POSTDESCBefore IMAS
DB Query Reader
Microsoft SQL ServerConnector IMAS_HRMS
Microsoft SQL Server Connector
Truncate IMASPO_POSITION_JOBS
DB SQL Executor
Validate POSTDESCvsPO_POSITION_JOBS
DB Query Reader
50: SHORTLIST
Microsoft SQL Server Connector
Insert IMASPO_POSITION_JOBS
DB SQL Executor
Validate IMASPO_POSITION_JOBSCount
DB Query Reader
Clean NOTAXNumeric DateColumns
String Manipulation (Multi Column)
Handle MissingNOTAX NumericString Columns
Missing Value
StatusTAX_AKHIR
Rule Engine
StatusTAX_MULA
Rule Engine
PrepareTAX_AKHIRParse Value
Rule Engine
PrepareTAX_MULAParse Value
Rule Engine
Rename toTAX_MULA_PARSED
Column Renamer
ParseTAX_MULA
String to Date&Time
Rename toTAX_AKHIR_PARSED
Column Renamer
ParseTAX_AKHIR
String to Date&Time
ValidateNOTAX
Rule Engine
FilterInvalid NOTAX
Rule-based Row Filter
StatisticNOTAX Status
GroupBy
FilterValid NOTAX
Rule-based Row Filter
Export InvalidNOTAX Records
Excel Writer
RenameNOTAX for F
Column Renamer
Select CleanNOTAX Columns
Column Filter
Truncate F NOTAX
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Read F NOTAX
DB Reader
Insert F NOTAX
DB Writer
Table F NOTAX
DB Table Selector
Raw Q_LEVEL
DB Reader
Q_LEVEL
DB Table Selector
Convert Q_LEVELInteger to String
Number to String
Convert Q_LEVELNumber to Integer
Double to Integer
Clean QLEV_ABBR
String Manipulation
Clean QLEV_KOD
String Manipulation
Validate Q_LEVEL
Rule Engine
Clean QLEV_DESC
String Manipulation
StatisticQ_LEVEL Status
GroupBy
Filter DuplicateQLEV_KOD
Rule-based Row Filter
DuplicateCheck QLEV_KOD
GroupBy
Read F ELNMAS
DB Reader
Truncate F ELNMAS
DB SQL Executor
Insert F ELNMAS
DB Writer
Table F ELNMAS
DB Table Selector
DEDMAS
DB Table Selector
Raw DEDMAS
DB Reader
Convert DEDMASInteger to String
Number to String
Convert DEDMASNumber to Integer
Double to Integer
Clean DED_KOD
String Manipulation
CleanDED_SLIP_DESC
String Manipulation
Clean DED_DESC
String Manipulation
Validate DEDMAS
Rule Engine
Clean DEDMASFlag and GLColumns
String Manipulation (Multi Column)
Check DuplicateDED_KOD
GroupBy
StatisticDEDMAS Status
GroupBy
Filter InvalidDEDMAS
Rule-based Row Filter
Filter DuplicateDED_KOD
Rule-based Row Filter
Export InvalidDEDMAS Records
Excel Writer
Select CleanDEDMAS Columns
Column Filter
Filter ValidDEDMAS
Rule-based Row Filter
Truncate F DEDMAS
DB SQL Executor
RenameDEDMAS for F
Column Renamer
Table F DEDMAS
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
Insert F DEDMAS
DB Writer
Read F DEDMAS
DB Reader
DEDUCTION
DB Table Selector
Raw DEDUCTION
DB Reader
Rename RawDEDUCTION Columns
Column Renamer
Convert DEDUCTIONInteger to String
Number to String
Convert DEDUCTIONNumber to Integer
Double to Integer
Clean DEDUCTIONNumeric StringColumns
String Manipulation (Multi Column)
Handle MissingDEDUCTIONNumeric StringColumns
Missing Value
Clean DED_REF
String Manipulation
Clean DED_TYPE
String Manipulation
Status END_DATE
Rule Engine
StatusSTART_DATE
Rule Engine
PrepareSTART_DATEParse Value
Rule Engine
Parse START_DATE
String to Date&Time
PrepareEND_DATEParse Value
Rule Engine
Parse END_DATE
String to Date&Time
Rename toSTART_DATE
Column Renamer
Validate DEDUCTION
Rule Engine
Rename toEND_DATE_PARSED
Column Renamer
Statistic DED_TYPE
GroupBy
StatisticDEDUCTION Status
GroupBy
Filter InvalidDEDUCTION
Rule-based Row Filter
Statistic DED_KOD
GroupBy
Export InvalidDEDUCTION Records
Excel Writer
Select CleanDEDUCTION Columns
Column Filter
Filter ValidDEDUCTION
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
RenameDEDUCTION for F
Column Renamer
Read F DEDUCTION
DB Reader
Truncate F DEDUCTION
DB SQL Executor
Insert FDEDUCTION
DB Writer
Table F DEDUCTION
DB Table Selector
Raw DEDACCNT
DB Reader
Convert DEDACCNTNumber to Integer
Double to Integer
DEDACCNT
DB Table Selector
Handle MissingDEDACCNTNumeric StringColumns
Missing Value
Convert DEDACCNTInteger to String
Number to String
CleanAKAUN_PTGN
String Manipulation
Clean DEDACCNTNumeric StringColumns
String Manipulation (Multi Column)
CleanFILLER_PTGN
String Manipulation
CleanSTATUS_PTGN
String Manipulation
Prepare TKH_UPDParse Value
Rule Engine
Status TKH_UPD
Rule Engine
Excel Writer
Filter inValidSCALESSM_D
Rule-based Row Filter
50: CLEANED DB
Microsoft SQL Server Connector
Parse TKH_UPD
String to Date&Time
Extract Table Dimension
Excel Writer
StatisticDEDACCNT Status
GroupBy
Validate DEDACCNT
Rule Engine
StatisticPOSTMASPOST_STA
GroupBy
Check DuplicateDEDACCNT Account
GroupBy
StatisticSTATUS_PTGN
GroupBy
StatisticPOSTMAS P_SKIM
GroupBy
Filter InvalidDEDACCNT
Rule-based Row Filter
Excel Writer
Filter DuplicateDEDACCNT Account
Rule-based Row Filter
Statistic DuplicatePOST_NO
GroupBy
Filter ValidDEDACCNT
Rule-based Row Filter
Excel Writer
Export InvalidDEDACCNT Records
Excel Writer
Excel Writer
Filter DuplicatePOST_NO
Rule-based Row Filter
Select CleanDEDACCNT Columns
Column Filter
Select CleanPOSTMAS Columns
Column Filter
FilterValid POSTMAS
Rule-based Row Filter
RenamePOSTMAS for F
Column Renamer
Truncate F DEDACCNT
DB SQL Executor
RenameDEDACCNT for F
Column Renamer
Table F DEDACCNT
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
CLEANED DB
Microsoft SQL Server Connector
Insert F DEDACCNT
DB Writer
Truncate FPOSTMAS
DB SQL Executor
Read F DEDACCNT
DB Reader
Table F POSTMAS
DB Table Selector
Raw NOTAX
DB Reader
Insert F POSTMAS
DB Writer
NOTAX
DB Table Selector
Rename POSTMASfor NORMALIZED
Column Renamer
Convert NOTAXInteger to String
Number to String
Read F POSTMAS
DB Reader
Convert NOTAXNumber to Integer
Double to Integer
NORMALIZED DB
Microsoft SQL Server Connector
Create POSTMASsource_key
Rule Engine
Select NORMALIZEDPOSTMAS Columns
Column Filter
Extract Table Dimension
Excel Writer
DB Reader
Excel Writer
Extract Table Dimension
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Excel Writer
Excel Writer
Extract Table Dimension
Truncateref_post_master
DB SQL Executor
Read F JAWATAN
DB Reader
Insertref_post_master
DB Writer
CLEANED DB
Microsoft SQL Server Connector
JAWATAN
DB Table Selector
Filter JAWATANPOST_NONot Empty
Rule-based Row Filter
CleanJAWATAN POST_NO
String Manipulation
NORMALIZED DB
Microsoft SQL Server Connector
DistinctJAWATAN POST_NO
GroupBy
Tableref_post_master
DB Table Selector
Extract Table Dimension
Excel Writer
DB Table Selector
DB Reader
Extract Table Dimension
Excel Writer
Excel Writer
Excel Writer
Extract Table Dimension
DB Table Selector
50: CLEANED DB
Microsoft SQL Server Connector
POSTMASReference Columns
Column Filter
Readref_post_master
DB Reader
StatusPOSTMAS Lookup
Rule Engine
CheckJAWATAN POST_NOvs POSTMAS
Joiner
Export POSTMASLookup Statistic
Excel Writer
StatisticPOSTMAS Lookup
GroupBy
Add MissingPOSTMAS IssueAction
Rule Engine
Filter MissingPOSTMAS Reference
Rule-based Row Filter
Missing POSTMASReference Columns
Column Filter
Add CorrectedPOST_NO Column
Constant Value Column Appender
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Extract Table Dimension
Excel Writer
Excel Writer
Extract Table Dimension
50: CLEANED DB
Microsoft SQL Server Connector
Export MissingPOSTMAS Reference
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Filter CorrectedPOSTMAS Reference
Rule-based Row Filter
Load MissingPOSTMAS Correction
Excel Reader
ValidatePOSTMASCorrection
Rule Engine
Create POSTMASpost_no_final
Rule Engine
StatusProposedCRET_DATE
Rule Engine
Filter ValidPOSTMAS Correction
Rule-based Row Filter
Extract Table Dimension
Select CorrectedPOSTMAS Columns
Column Filter
Parse ProposedCRET_DATE
String to Date&Time
Rename CorrectedPOSTMAS Columns
Column Renamer
Excel Writer
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
Excel Writer
Extract Table Dimension
Excel Writer
Table F WARIS
DB Table Selector
Extract Table Dimension
Add POSTMASsource_system
Constant Value Column Appender
Excel Writer
Create CorrectedPOSTMAS source_key
Rule Engine
Read F WARIS
DB Reader
Final CorrectedPOSTMAS Columns
Column Filter
Readref_post_master
DB Reader
Tableref_post_master
DB Table Selector
NORMALIZED DB
Microsoft SQL Server Connector
Combineref_post_masterwith Correction
Concatenate
Originalref_post_masterColumns
Column Filter
Excel Writer
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
Remove DuplicatePOSTMAS post_no
Duplicate Row Filter
Excel Writer
Reloadref_post_master
DB Writer
Excel Writer
Truncateref_post_master
DB SQL Executor
50: CLEANED DB
Microsoft SQL Server Connector
Raw POSTHISTORY
DB Reader
POSTHISTORY
DB Table Selector
Rename RawPOSTHISTORYColumns
Column Renamer
ConvertPOSTHISTORYNumber to Integer
Double to Integer
ConvertPOSTHISTORYInteger to String
Number to String
Extract Table Dimension
Clean POSTHISTORYNumeric String Columns
String Manipulation (Multi Column)
Excel Writer
Clean POST_STA
String Manipulation
Excel Writer
Excel Writer
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
Excel Writer
Clean POST_REF
String Manipulation
Excel Writer
Clean POST_KJ
String Manipulation
Extract Table Dimension
StatusJ_ENDATE
Rule Engine
Excel Writer
Status TARIKH_MULA
Rule Engine
Extract Table Dimension
Rename TARIKH_MULA_DT
Column Renamer
ParseTARIKH_MULA Date
String to Date&Time
Rename J_ENDATE_DT
Column Renamer
ParseTARIKH_MULA Date
String to Date&Time
Statistic POSTHISTORYStatus
GroupBy
Extract Table Dimension
ValidatePOSTHISTORY
Rule Engine
Excel Writer
StatisticOLDPOST Status
GroupBy
Excel Writer
Duplicate CheckOLDPOST Code
GroupBy
50: CLEANED DB
Microsoft SQL Server Connector
StatisticPOSTHISTORYPOST_STA
GroupBy
CleanOPOST_DESC
String Manipulation
Extract Table Dimension
Validate OLDPOST
Rule Engine
Excel Writer
StatisticPOSTHISTORYPOST_REF
GroupBy
Filter InvalidOLDPOST
Rule-based Row Filter
StatisticPOSTHISTORYPOST_KJ
GroupBy
Export InvalidOLDPOST Records
Excel Writer
Filter InvalidPOSTHISTORY
Rule-based Row Filter
Filter DuplicateOLDPOST Code
Rule-based Row Filter
Excel Writer
Filter ValidPOSTHISTORY
Rule-based Row Filter
Export duplicate
Excel Writer
Select CleanPOSTHISTORY Columns
Column Filter
Export InvalidPOSTHISTORYRecords
Excel Writer
Excel Writer
Truncate FPOSTHISTORY
DB SQL Executor
RenamePOSTHISTORYfor F
Column Renamer
Excel Writer
CLEANED DB
Microsoft SQL Server Connector
CleanOPOST_KOD
String Manipulation
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
Excel Writer
Extract Table Dimension
Table FPOSTHISTORY
DB Table Selector
Excel Writer
Insert FPOSTHISTORY
DB Writer
50: CLEANED DB
Microsoft SQL Server Connector
RenamePOSTHISTORYfor NORMALIZED
Column Renamer
Read FPOSTHISTORY
DB Reader
LookupPOSTHISTORYStaff Master
Joiner
Extract Table Dimension
CreatePOSTHISTORYsource_key
String Manipulation
Excel Writer
NORMALIZED DB
Microsoft SQL Server Connector
Tablestaff_master
DB Table Selector
StatusPOSTHISTORYStaff Lookup
Rule Engine
Read NORMALIZED_HRstaff_master
DB Reader
Extract Table Dimension
Excel Writer
Extract Table Dimension
Excel Writer
Extract Table Dimension
Excel Writer
POSTMAS
DB Table Selector
Excel Writer
Raw POSTMAS
DB Reader
50: CLEANED DB
Microsoft SQL Server Connector
Convert POSTMASNumber to Integer
Double to Integer
Rename RawPOSTMAS Columns
Column Renamer
Clean POSTMASNumeric String Columns
String Manipulation (Multi Column)
Convert POSTMASInteger to String
Number to String
Clean P_SKIM
String Manipulation
Excel Writer
Clean J_SCALE
String Manipulation
Extract Table Dimension
Clean P_QTRS
String Manipulation
Clean POST_STA
String Manipulation
Excel Writer
Filter ValidHISPOSTMARA
Rule-based Row Filter
Excel Writer
Extract Table Dimension
Clean GRED_JKK
String Manipulation
Excel Writer
Excel Writer
Filter ValidCRET_DATE For Parse
Rule-based Row Filter
Extract Table Dimension
Status CRET_DATE
Rule Engine
Excel Writer
Filter CRET_DATE No Date
Rule-based Row Filter
ParseCRET_DATEDate
String to Date&Time
CombineCRET_DATEDate Branch
Concatenate
50: CLEANED DB
Microsoft SQL Server Connector
Add EmptyCRET_DATE Date
Constant Value Column Appender
StatisticPOSTMAS Status
GroupBy
Validate POSTMAS
Rule Engine
Excel Writer
Extract Table Dimension
Excel Writer
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Read F URUSAN
DB Reader
Extract Table Dimension
Table F URUSAN
DB Table Selector
Excel Writer
Excel Writer
Extract Table Dimension
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Excel Writer
Filter InValidURUSAN
Rule-based Row Filter
Clean ELN_EPF
String Manipulation
Validate ELNMAS
Rule Engine
Clean ELN_SOCSO
String Manipulation
DuplicateCheck ELN_KOD
GroupBy
StatisticELNMAS Status
GroupBy
Filter InvalidELNMAS
Rule-based Row Filter
Filter DuplicateELN_KOD
Rule-based Row Filter
Filter ValidELNMAS
Rule-based Row Filter
Export InvalidELNMAS Records
Excel Writer
Select CleanELNMAS Columns
Column Filter
CLEANED DB
Microsoft SQL Server Connector
RenameELNMAS for F
Column Renamer
Convert WARISNumber to Integer
Double to Integer
Rename RawWARIS Columns
Column Renamer
Clean NO_GAJI
String Manipulation
Convert WARISInteger to String
Number to String
Clean WAR_TEL
String Manipulation
Clean string column
String Manipulation (Multi Column)
CleanWAR_NEW_KP
String Manipulation
CleanWAR_OLD_KP
String Manipulation
Status WAR_TEL
Rule Engine
StatusWAR_POSKOD
Rule Engine
Status WAR_NEW_KP
Rule Engine
Statistic WARIS Status
GroupBy
Validate WARIS
Rule Engine
StatisticWARIS Telephone
GroupBy
Statistic WARISPoskod
GroupBy
Statistic WARISby NO_GAJI
GroupBy
StatisticWARIS New KP
GroupBy
Select CleanWARIS Columns
Column Filter
Filter Valid WARIS
Rule-based Row Filter
RenameWARIS for F
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
Truncate F WARIS
DB SQL Executor
Filter Invalid WARIS
Rule-based Row Filter
Insert F WARIS
DB Writer
Raw TANGGUH
DB Reader
Convert TANGGUHNumber to Integer
Double to Integer
TANGGUH
DB Table Selector
Clean TANGGUHNumeric StringColumns
String Manipulation (Multi Column)
Convert TANGGUHInteger to String
Number to String
CleanKOD_TANGGUH
String Manipulation
StatusTKH_TANGGUH
Rule Engine
Status TKH_ASAL
Rule Engine
PrepareTKH_ASALParse Value
Rule Engine
StatusTKH_ENTRY
Rule Engine
PrepareTKH_ENTRYParse Value
Rule Engine
PrepareTKH_TANGGUHParse Value
Rule Engine
RenameTKH_ASAL_PARSED
Column Renamer
Parse TKH_ASAL
String to Date&Time
ParseTKH_TANGGUH
String to Date&Time
Excel Writer
Extract Table Dimension
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
ParseTKH_ENTRY
String to Date&Time
RenameTKH_TANGGUH_PARSED
Column Renamer
ValidateTANGGUH
Rule Engine
RenameTKH_TANGGUH_PARSED
Column Renamer
StatisticKOD_TANGGUH
GroupBy
StatisticTANGGUH Status
GroupBy
TANGGUH IssueList Columns
Column Filter
FilterInvalid TANGGUH
Rule-based Row Filter
Add TANGGUHAction Remark
Constant Value Column Appender
Add TANGGUHCorrection Value
Constant Value Column Appender
Export TANGGUHInvalid Records
Excel Writer
Select CleanTANGGUH Columns
Column Filter
FilterValid TANGGUH
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
RenameTANGGUH for F
Column Renamer
Insert FTANGGUH
DB Writer
Truncate F TANGGUH
DB SQL Executor
Read F TANGGUH
DB Reader
Table F TANGGUH
DB Table Selector
Statistic F TANGGUH Status
GroupBy
Excel Writer
Excel Writer
Extract Table Dimension
Excel Writer
Excel Writer
Extract Table Dimension
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
Excel Writer
Raw ELAUN
DB Reader
ELAUN
DB Table Selector
Convert ELAUNInteger to String
Number to String
Convert ELAUNNumber to Integer
Double to Integer
Clean ELN_TYPE
String Manipulation
Clean ELAUNNumeric StringColumns
String Manipulation (Multi Column)
StatusELN_END
Rule Engine
StatusELN_START
Rule Engine
Filter ParseReady ELN_START
Rule-based Row Filter
Prepare ELN_STARTParse Value
Rule Engine
Excel Writer
Extract Table Dimension
Excel Writer
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Extract Table Dimension
Extract Table Dimension
Excel Writer
Prepare ELN_ENDParse Value
Rule Engine
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
ParseELN_START
String to Date&Time
Filter ParseReady ELN_END
Rule-based Row Filter
Rename parseto date
Column Renamer
Parse ELN_END
String to Date&Time
StatisticELAUN Status
GroupBy
Validate ELAUN
Rule Engine
StatisticELN_TYPE
GroupBy
Export ELAUNStatus Statistic
Excel Writer
StatisticELN_KOD
GroupBy
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Extract Table Dimension
Excel Writer
Excel Writer
Excel Writer
Extract Table Dimension
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
Export InvalidELAUN Records
Excel Writer
Excel Writer
Filter InvalidELAUN
Rule-based Row Filter
Excel Writer
Select CleanELAUN Columns
Column Filter
Filter Valid ELAUN
Rule-based Row Filter
Checkstaff_service vs POSTDESC
Joiner
Truncate F ELAUN
DB SQL Executor
Readref_position_description
DB Reader
RenameELAUN for F
Column Renamer
Statistic Position Lookup
GroupBy
Table F ELAUN
DB Table Selector
StatusPosition Lookup
Rule Engine
CLEANED DB
Microsoft SQL Server Connector
MissingPosition Summary
GroupBy
Insert F ELAUN
DB Writer
Filter MissingPosition Reference
Rule-based Row Filter
Read F ELAUN
DB Reader
Add PositionAction Remark
Constant Value Column Appender
Add ProposedPosition Desc
Constant Value Column Appender
Load MissingPosition Correction
Excel Reader
Export MissingPosition Reference
Excel Writer
Excel Writer
Extract Table Dimension
Extract Table Dimension
Excel Writer
50: CLEANED DB
Microsoft SQL Server Connector
Extract Table Dimension
Excel Writer
ELNMAS
DB Table Selector
Excel Writer
Excel Writer
Convert ELNMASNumber to Integer
Double to Integer
Excel Writer
Raw ELNMAS
DB Reader
Extract Table Dimension
FilterCorrected Position
Rule-based Row Filter
Clean ELN_KOD
String Manipulation
Convert ELNMASInteger to String
Number to String
ValidateCorrected Position
Rule Engine
Clean ELN_SLIP_DESC
String Manipulation
CreatePosition Desc Final
Rule Engine
Clean ELN_DESC
String Manipulation
Select CorrectedPosition Columns
Column Filter
Clean ELN_GL_KOD
String Manipulation
Filter ValidPositionCorrection
Rule-based Row Filter
Clean ELN_GL_SIGN
String Manipulation
Add CorrectionETL Status
Constant Value Column Appender
Rename CorrectedPosition Columns
Column Renamer
Clean ELN_TAX
String Manipulation
Originalref_position_descriptionColumns
Column Filter
Final CorrectedPosition Columns
Column Filter
Combineref_position_descriptionwith Correction
Concatenate
50: CLEANED DB
Microsoft SQL Server Connector
GroupBy
Excel Writer
Excel Writer
Extract Table Dimension
Extract Table Dimension
Select POSTDESCMigration Columns
Column Filter
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Truncateref_position_descriptionReload
DB SQL Executor
Removeduplicateposition_code
Duplicate Row Filter
Add emptyjpa_code
Constant Value Column Appender
Reloadref_position_description
DB Writer
Raw JAWATAN
DB Reader
Extract Table Dimension
JAWATAN
DB Table Selector
50: SHORTLIST
Microsoft SQL Server Connector
Extract Table Dimension
Excel Writer
Excel Writer
Extract Table Dimension
Extract Table Dimension
50: CLEANED DB
Microsoft SQL Server Connector
Excel Writer
Excel Writer
Excel Writer
50: SHORTLIST
Microsoft SQL Server Connector
Rename RawJAWATAN Columns
Column Renamer
Excel Writer
Convert Integerto String
Number to String
ConvertNumberto Integer
Double to Integer
Clean NumericString Columns
String Manipulation (Multi Column)
Apply correction
Excel Reader
Renamecolumn for F
Column Renamer
Prepare URUSAN Staging
DB SQL Executor
Filter column for F
Column Filter
Load URUSAN Staging
DB Writer
DuplicateBINTANG_MBTNG_JENIS Check
Rule-based Row Filter
Select URUSANMigration Columns
Column Filter
Filter valid data
Rule-based Row Filter
50: DBHR_POPP
Microsoft SQL Server Connector
Corrected join
Joiner
Table FBINTANG_M
DB Table Selector
bank_code_final
Rule Engine
Truncate F BINTANG_M
DB SQL Executor
Clean POST_REF
String Manipulation
Write to F
DB Writer
Validate URUSAN Staging
DB Query Reader
Clean POST_STA
String Manipulation
CLEANED DB
Microsoft SQL Server Connector
Migrate URUSAN to PP_BUSINESSES
DB SQL Executor
bank_status_final
Rule Engine
StatusDATE_CONFIRMED
Rule Engine
final_status
GroupBy
StatusJ_STARTDATE
Rule Engine
bank_desc_final
Rule Engine
rename toJ_STARTDATE_DT
Column Renamer
selected column
Column Filter
ParseJ_STARTDATEDate
String to Date&Time
Clean EMPMAS BANK_CODE
String Manipulation
rename toDATE_CONFIRMED_DT
Column Renamer
POSTDESC Post-Migration Summary
DB Query Reader
EMPMAS BANK_CODE not empty
Rule-based Row Filter
ParseDATE_CONFIRMEDDate
String to Date&Time
Excel Writer
Table EMPMAS
DB Table Selector
Filter ValidJAWATAN
Rule-based Row Filter
Validate POSTDESC Staging
DB Query Reader
Raw EMPMAS
DB Reader
Validate JAWATAN
Rule Engine
Migrate POSTDESC to PO_POSITION_JOBS
DB SQL Executor
Excel Writer
50: IMAS.DBHR_POPP
Microsoft SQL Server Connector
Migrate POSTDESC to PO_POSITION_JOBS
DB SQL Executor
POSTDESC Post-Migration Summary
DB Query Reader
Distinct EMPMAS BANK_CODE
Column Renamer
Select CleanJAWATAN Columns
Column Filter
Load POSTDESC Staging
DB Writer
BANKCODE final valid only
Rule-based Row Filter
Write to F
DB Writer
Select POSTDESC Migration Columns
Column Filter
GroupBy
RenameJAWATAN for F
Column Renamer
Prepare POSTDESC Staging
DB SQL Executor
Missing BANKCODE reference from EMPMAS
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
PROPOSED_BANK_DESC
Constant Value Column Appender
truncate table
Text View
BANKCODE final reference
Column Filter
Statistic POST_STA
GroupBy
Check EMPMAS BANK_CODE vs BANKCODE
Joiner
Statistic JAWATAN Status
GroupBy
Load EMPMAS missing bank correction
Excel Reader
StatisticNO_GAJIPost Count
GroupBy
Load POSTDESC Staging
DB Writer
Statistic POST_REF
GroupBy
Validate POSTDESC Staging
DB Query Reader
ACTION REMARK
Constant Value Column Appender
Excel Writer
Filter NO_GAJIMultiple Post
Rule-based Row Filter
Prepare POSTDESC Staging
DB SQL Executor
Truncate F NEWSCALE_M
DB SQL Executor
RenameColumn for F
Column Renamer
Clean NEWSCALE_D SSB_KOD_GRED
String Manipulation
Write to F
DB Writer
Filter column for F
Column Filter
Export InvalidJAWATAN Records
Excel Writer
Duplicate NEWSCALE_DGrade Step Check
Rule-based Row Filter
Filter InvalidJAWATAN
Rule-based Row Filter
Filter valid data
Rule-based Row Filter
Table F JAWATAN
DB Table Selector
ValidateNEWSCALE_D
Rule Engine
Duplicate check
GroupBy
RenameJAWATAN forNORMALIZED
Column Renamer
Read F JAWATAN
DB Reader
Tablestaff_master
DB Table Selector
SelectNORMALIZEDJAWATAN Columns
Column Filter
Readstaff_master
DB Reader
Read FNEWSCALE_M
DB Reader
NORMALIZED DB
Microsoft SQL Server Connector
CLEANED DB
Microsoft SQL Server Connector
Read FBINTANG_M
DB Reader
ConvertNEWSCALE_MNumber to Integer
Double to Integer
StatusNEWSCALE_MDescription
Rule Engine
Migrate OLDPOST to PO_POSITION_JOB_OLDS
DB SQL Executor
StatisticNEWSCALE_M
GroupBy
OLDPOST Post-MigrationSummary
DB Query Reader
staff_mastersalary_no reference
Column Filter
CleanNEWSCALE_MColumns
String Manipulation (Multi Column)
Load OLDPOST Staging
DB Writer
ValidateNEWSCALE_M
Rule Engine
Validate OLDPOST Staging
DB Query Reader
StatusJAWATAN StaffLookup
Rule Engine
DuplicateNEWSCALE_M
Rule-based Row Filter
Issues list
Rule-based Row Filter
Check JAWATANsalary_no vsstaff_master
Joiner
Table FNEWSCALE_M
DB Table Selector
ValidateNORMALIZEDJAWATAN
Rule Engine
Statistic NEWSCALE_MDescription
GroupBy
Export OLDPOSTPost-Migration Report
Excel Writer
Set PositionLookup NotValidated
Constant Value Column Appender
Check duplicate
GroupBy
Cleaned Column
Column Filter
Rename statusforstaff_position_assignment
Column Renamer
Rename column
Column Renamer
Selectstaff_position_assignment Columns
Column Filter
URUSAN Post-MigrationSummary
DB Query Reader
Export Issue
Excel Writer
Insertstaff_position_assignment
DB Writer
VALID only
Rule-based Row Filter
Truncatestaff_position_assignment
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
50: DBHR_POPP
Microsoft SQL Server Connector
check
Text View
StatisticNORMALIZED JAWATAN
GroupBy
Convert NEWSCALE_MInteger to String
Number to String
Prepare OLDPOSTStaging
DB SQL Executor
Check duplicate codes
Duplicate Row Filter
Excel Writer
Insert to Cleansing DB
DB Writer
Select OLDPOSTMigration Columns
Column Filter
Clean DEP_NAME
String Manipulation
Clean DEP_IC_BC
String Manipulation
RenameCorrectedSchemeColumns
Column Renamer
Clean DEPENDENTSNumeric StringColumns
String Manipulation (Multi Column)
CleanRELATIONSHIP
String Manipulation
Final CorrectedScheme Columns
Column Filter
CleanDEP_LAYAKTAX
String Manipulation
SelectCorrectedScheme Columns
Column Filter
Addempty jpa_code
Constant Value Column Appender
Clean DEP_HEALTH
String Manipulation
Combineref_service_schemewith Correction
Concatenate
CleanDEP_BELAJAR
String Manipulation
Addcorrectionetl_status
Constant Value Column Appender
Addempty grade_scheme
Constant Value Column Appender
Combineref_service_schemewith Correction
Concatenate
Originalref_service_schemeColumns
Column Filter
Convert DEPENDENTSInteger to String
Number to String
Removeduplicateservice_scheme_code
Duplicate Row Filter
Handle MissingDEPENDENTS NumericString Columns
Missing Value
Convert DEPENDENTSNumber to Integer
Double to Integer
Filter Valid OLDPOST
Rule-based Row Filter
Table FOLDPOST
DB Table Selector
Extract Table Dimension
Truncate F OLDPOST
DB SQL Executor
Excel Writer
Reloadref_service_scheme
DB Writer
Read FOLDPOST
DB Reader
Extract Table Dimension
Truncateref_service_scheme
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Excel Writer
POSTDESC
DB Table Selector
DEPENDENTS
DB Table Selector
Raw POSTDESC
DB Reader
Rename RawDEPENDENTS Columns
Column Renamer
Clean POST_DESC
String Manipulation
Insert F OLDPOST
DB Writer
Clean POST_CODE
String Manipulation
Raw DEPENDENTS
DB Reader
StatisticPOSTDESC Status
GroupBy
Extract Table Dimension
Validate POSTDESC
Rule Engine
Extract Table Dimension
FilterDuplicatePOST_CODE
Rule-based Row Filter
StatisticDuplicatePOST_CODE
GroupBy
Select CleanOLDPOST Columns
Column Filter
50: CLEANED DB
Microsoft SQL Server Connector
RenameOLDPOST for F
Column Renamer
Excel Writer
Excel Writer
Excel Writer
ExportDuplicatePOST_CODE
Excel Writer
Truncate F DEPENDENTS
DB SQL Executor
Table FDEPENDENTS
DB Table Selector
Select CleanPOSTDESCColumns
Column Filter
Select CleanDEPENDENTS Columns
Column Filter
FilterValid POSTDESC
Rule-based Row Filter
RenameDEPENDENTS for F
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
RenamePOSTDESC for F
Column Renamer
Insert F POSTDESC
DB Writer
CLEANED DB
Microsoft SQL Server Connector
TruncateF POSTDESC
DB SQL Executor
ReadF POSTDESC
DB Reader
Table F POSTDESC
DB Table Selector
Filter DuplicateDEPENDENTS
Rule-based Row Filter
Clean KOD_JPA
String Manipulation
Export InvalidDEPENDENTS Records
Excel Writer
Filter ValidDEPENDENTS
Rule-based Row Filter
Export duplicate
Excel Writer
Filter InvalidDEPENDENTS
Rule-based Row Filter
StatisticF POSTDESC
GroupBy
StatisticDEPENDENTS Relationship
GroupBy
Statistic KOD_JPA
GroupBy
StatisticDEP_BELAJAR
GroupBy
SelectNORMALIZEDPOSTDESC Columns
Column Filter
Validate DEPENDENTS
Rule Engine
RenamePOSTDESC forNORMALIZED
Column Renamer
StatisticDEPENDENTS Status
GroupBy
NORMALIZED DB
Microsoft SQL Server Connector
Truncateref_position_description
DB SQL Executor
Tablestaff_service
DB Table Selector
StatisticDEP_LAYAKTAX
GroupBy
Insertref_position_description
DB Writer
DuplicateDEPENDENTS Check
GroupBy
Tableref_position_description
DB Table Selector
Read staff_service
DB Reader
Parse EP_BIRTHDATE
String to Date&Time
ParseDEP_BIRTHDATE
Column Renamer
StatusDEP_BIRTHDATE
Rule Engine
PrepareDEP_BIRTHDATEParse Value
Rule Engine
Statistic SPOUSE Status
GroupBy
Status SI_TAX
Rule Engine
Validate SPOUSE
Rule Engine
Clean SPOUSEAddress Columns
String Manipulation (Multi Column)
Clean SI_TEL
String Manipulation
Clean SI_COMPANY
String Manipulation
Clean SI_POSKOD
String Manipulation
Status SI_POSKOD
Rule Engine
Clean SI_TAX
String Manipulation
Clean SPOUSEFlag Columns
String Manipulation (Multi Column)
CleanSPOUSE NO_GAJI
String Manipulation
Clean SI_NAME
String Manipulation
Convert SPOUSEInteger to String
Number to String
Handle MissingSPOUSE NumericString Columns
Missing Value
Read FDEPENDENTS
DB Reader
Insert FDEPENDENTS
DB Writer
Rename RawSPOUSE Columns
Column Renamer
Convert SPOUSENumber to Integer
Double to Integer
SPOUSE
DB Table Selector
Raw SPOUSE
DB Reader
Filter Valid SPOUSE
Rule-based Row Filter
Excel Writer
CLEANED DB
Microsoft SQL Server Connector
Table FSPOUSE
DB Table Selector
Select CleanSPOUSE Columns
Column Filter
Rename SPOUSE for F
Column Renamer
Insert F SPOUSE
DB Writer
SOURCE: SHORTLIST
Microsoft SQL Server Connector
Truncate F SPOUSE
DB SQL Executor
Read FSPOUSE
DB Reader
Export InvalidSPOUSE Records
Excel Writer
Export MultipleSPOUSE by Staff
Excel Writer
StatisticSI_TAX Status
GroupBy
Count SPOUSEby NO_GAJI
GroupBy
Statistic SI_KERJA
GroupBy
StatisticSI_POSKOD Status
GroupBy
Filter DuplicateSPOUSE Exact
Rule-based Row Filter
Filter Invalid SPOUSE
Rule-based Row Filter
Filter MultipleSPOUSE by Staff
Rule-based Row Filter
Duplicate SPOUSEExact Check
GroupBy
BINTANG_M
DB Table Selector
Raw BINTANG_M
DB Reader
NEWSCALE_D
DB Table Selector
Raw NEWSCALE_D
DB Reader
NEWSCALE_M
DB Table Selector
Raw NEWSCALE_M
DB Reader
StatisticBINTANG_M Status
GroupBy
Check duplicate
GroupBy
Clean column
String Manipulation (Multi Column)
Validate BINTANG_M
Rule Engine
Select CleanBINTANG Columns
Column Filter
Export Invalid
Excel Writer
CLEANED DB
Microsoft SQL Server Connector
Rename BINTANG for F
Column Renamer
Truncate F BINTANG
DB SQL Executor
Table FBINTANG
DB Table Selector
Read FBINTANG
DB Reader
Raw PREVPOST
DB Reader
Insert F BINTANG
DB Writer
Convert PREVPOSTNumber to Integer
Double to Integer
PREVPOST
DB Table Selector
Handle MissingPREVPOST NumericString Columns
Missing Value
Convert PREVPOSTInteger to String
Number to String
CleanPPOST_STATUS
String Manipulation
Clean PREVPOSTNumeric StringColumns
String Manipulation (Multi Column)
Clean PPOST_REF
String Manipulation
Status PPOST_END
Rule Engine
StatusPPOST_START
Rule Engine
Prepare PPOST_ENDParse Value
Rule Engine
PreparePPOST_STARTParse Value
Rule Engine
RenamePPOST_START_DATE
Column Renamer
Parse PPOST_START
String to Date&Time
RenamePPOST_END_DATE
Column Renamer
Parse PPOST_END
String to Date&Time
StatisticPREVPOST Status
GroupBy
Validate PREVPOST
Rule Engine
50: DBHR_POPP
Microsoft SQL Server Connector
Prepare BINTANG_M Staging
DB SQL Executor
Select BINTANG_M Migration Columns
Column Filter
StatisticPPOST_STATUS
GroupBy
DuplicateCheck PREVPOST
GroupBy
StatisticPPOST_REF
GroupBy
Truncate staff_service_history
DB SQL Executor
Export duplicate
Excel Writer
Filter DuplicatePREVPOST
Rule-based Row Filter
URUSAN
DB Table Selector
Export InvalidPREVPOST Records
Excel Writer
Insertstaff_service_history
DB Writer
Filter InvalidPREVPOST
Rule-based Row Filter
ConvertURUSANNumber to Integer
Double to Integer
Select CleanPREVPOST Columns
Column Filter
Raw URUSAN
DB Reader
Filter ValidPREVPOST
Rule-based Row Filter
Clean URUSAN
String Manipulation
ConvertURUSANInteger to String
Number to String
RenamePREVPOST for F
Column Renamer
Validate URUSAN
Rule Engine
Clean URUS_DESC
String Manipulation
StatisticURUSAN Status
GroupBy
Table FPREVPOST
DB Table Selector
Read FPREVPOST
DB Reader
Truncate F PREVPOST
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
FilterDuplicateURUSAN
Rule-based Row Filter
OLDPOST
DB Table Selector
StatisticDuplicateURUSAN
GroupBy
Insert F PREVPOST
DB Writer
Filter ValidURUSAN
Rule-based Row Filter
Convert OLDPOSTNumber to Integer
Double to Integer
ExportDuplicateURUSAN
Excel Writer
Raw OLDPOST
DB Reader
RenameURUSAN for F
Column Renamer
Handle MissingOLDPOST NumericString Columns
Missing Value
Select CleanURUSAN Columns
Column Filter
Convert OLDPOSTInteger to String
Number to String
Truncate F URUSAN
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Raw SCALESSM_D
DB Reader
Insert F URUSAN
DB Writer
Convert SKIMMAS Numbers to Integer
Double to Integer
Convert SKIMMASNumbers to String
Number to String
UNIVERSITY Post-Migration Summary
DB Query Reader
Export UNIVERSITYPost-Migration Report
Excel Writer
Handle MissingSKIMMAS Values
Missing Value
Clean SKIMMASColumns
String Manipulation (Multi Column)
Select SKIMMASMigration Columns
Column Filter
Load SKIMMASStaging
DB Writer
Validate SKIMMASStaging
DB Query Reader
50: DBHR_POPP
Microsoft SQL Server Connector
Prepare SKIMMASStaging
DB SQL Executor
SCALESSM_D
DB Table Selector
ValidateSCALESSM_D
Rule Engine
Clean SSM_KOD_GRED
String Manipulation
Statistic DuplicateGred Tangga
GroupBy
StatisticSCALESSM_DStatus
GroupBy
Filter ValidSCALESSM_D
Rule-based Row Filter
Filter DuplicateGred Tangga
Rule-based Row Filter
RenameSCALESSM_Dfor F
Column Renamer
Select CleanSCALESSM_DColumns
Column Filter
CLEANED DB
Microsoft SQL Server Connector
Migrate BINTANG_M to PP_AWARDS
DB SQL Executor
BINTANG_M Post-Migration Summary
DB Query Reader
Load BINTANG_M Staging
DB Writer
Validate BINTANG_M Staging
DB Query Reader
50: DBHR_POPP
Microsoft SQL Server Connector
Export BINTANG_MPost-Migration Report
Excel Writer
Select UNIVERSITY Migration Columns
Column Filter
Validate UNIVERSITY Staging
DB Query Reader
Migrate UNIVERSITY to PP_INSTITUTES
DB SQL Executor
Prepare UNIVERSITY Staging
DB SQL Executor
Load UNIVERSITY Staging
DB Writer
Insert F SCALESSM_D
DB Writer
Truncate F SCALESSM_D
DB SQL Executor
SCALESSM_M
DB Table Selector
Raw SCALESSM_M
DB Reader
CleanSSM_KOD_DESC
String Manipulation
CleanSSM_KOD_GRED
String Manipulation
ConvertSCALESSM_MNumber to Integer
Double to Integer
Clean otherstring column
String Manipulation (Multi Column)
CleanSCALESSM_MNumeric StringColumns
String Manipulation (Multi Column)
ConvertSCALESSM_MInteger to String
Number to String
50: DBHR_POPP
Microsoft SQL Server Connector
Prepare Q_LEVELStaging
DB SQL Executor
Export EDUMASPost-Migration Report
Excel Writer
Select Q_LEVELMigration Columns
Column Filter
Validate Q_LEVEL Staging
DB Query Reader
Migrate Q_LEVEL to PP_QUALIFICATION_LEVELS
DB SQL Executor
Load Q_LEVEL Staging
DB Writer
Select SIJILTECHMigration Columns
Column Filter
50: DBHR_POPP
Microsoft SQL Server Connector
Q_LEVEL Post-MigrationSummary
DB Query Reader
Export Q_LEVELPost-Migration Report
Excel Writer
Status SSM_DATE
Rule Engine
Parse SSM_DATE
String to Date&Time
PrepareSSM_DATEParse Value
Rule Engine
ValidateSCALESSM_M
Rule Engine
rename toSSM_DATE_PARSED
Column Renamer
StatisticDuplicateSSM_KOD_GRED
GroupBy
StatisticSCALESSM_MStatus
GroupBy
Filter ValidSCALESSM_M
Rule-based Row Filter
FilterDuplicateSSM_KOD_GRED
Rule-based Row Filter
Select CleanSCALESSM_MColumns
Column Filter
Export SKIMMASPost-Migration Report
Excel Writer
Select EDUMASMigration Columns
Column Filter
Migrate SKIMMAS to PO_POSITION_SCHEMES
DB SQL Executor
SKIMMAS Post-MigrationSummary
DB Query Reader
50: DBHR_POPP
Microsoft SQL Server Connector
Prepare EDUMASStaging
DB SQL Executor
Load EDUMAS Staging
DB Writer
Migrate EDUMAS to PP_STUDY_FIELDS
DB SQL Executor
EDUMAS Post-MigrationSummary
DB Query Reader
Validate EDUMAS Staging
DB Query Reader
Check PP_STUDY_FIELDS Dependencies
DB Query Reader
CLEANED DB
Microsoft SQL Server Connector
RenameSCALESSM_Mfor F
Column Renamer
InsertF SCALESSM_M
DB Writer
Truncate F SCALESSM_M
DB SQL Executor
Raw KELAYAKAN
DB Reader
KELAYAKAN
DB Table Selector
Convert KELAYAKANInteger to String
Number to String
ConvertKELAYAKANNumber to Integer
Double to Integer
ValidateKELAYAKAN
Rule Engine
Clean KELAYAKANNumeric StringColumns
String Manipulation (Multi Column)
Migrate IKTISAS_M to PP_IKTISAS
DB SQL Executor
IKTISAS_MPost-Migration Summary
DB Query Reader
Map PostponeCategory Name
Rule Engine
Validate CategoryMapping
Rule Engine
Filter Non-EmptyKOD_TANGGUH
Rule-based Row Filter
GroupKOD_TANGGUH
GroupBy
50: DBHR_POPP
Microsoft SQL Server Connector
Prepare TANGGUHCategory Staging
DB SQL Executor
StatisticKELAYAKAN Status
GroupBy
Select CategoryStaging Columns
Column Filter
Column Renamer
StatisticDuplicateKELAYAKAN
GroupBy
Export KELAYAKANStatus Statistic
Excel Writer
Export DuplicateKELAYAKAN
Excel Writer
Filter DuplicateKELAYAKAN
Rule-based Row Filter
Filter InvalidKELAYAKAN
Rule-based Row Filter
Filter ValidKELAYAKAN
Rule-based Row Filter
Export IKTISAS_MPost-Migration Report
Excel Writer
Select CleanKELAYAKANColumns
Column Filter
Export InvalidKELAYAKANRecords
Excel Writer
RenameKELAYAKANfor F
Column Renamer
Validate SIJILTECH Staging
DB Query Reader
Prepare SIJILTECH Staging
DB SQL Executor
Load SIJILTECH Staging
DB Writer
Export SIJILTECHPost-Migration Report
Excel Writer
Select IKTISAS_M Migration Columns
Column Filter
Migrate SIJILTECH to PP_TECH_CERTIFICATES
DB SQL Executor
SIJILTECH Post-MigrationSummary
DB Query Reader
Load IKTISAS_M Staging
DB Writer
Validate IKTISAS_M Staging
DB Query Reader
CLEANED DB
Microsoft SQL Server Connector
50: DBHR_POPP
Microsoft SQL Server Connector
Truncate F KELAYAKAN
DB SQL Executor
Prepare IKTISAS_M Staging
DB SQL Executor
Table F KELAYAKAN
DB Table Selector
Insert F KELAYAKAN
DB Writer
Read F KELAYAKAN
DB Reader
EDUMAS
DB Table Selector
Raw EDUMAS
DB Reader
Convert EDUMASInteger to String
Number to String
Convert EDUMASNumber to Integer
Double to Integer
PrepareJ_STARTDATEParse
Rule Engine
50: DBHR_POPP
Microsoft SQL Server Connector
Prepare DATE_CONFIRMEDParse
Rule Engine
Profile SSM Target Lookups
DB Query Reader
Duplicate grain
DB Query Reader
StatusDATE_CONFIRMED
Rule Engine
Without master
DB Query Reader
Clean EDU_KOD
String Manipulation
Parse DATE_CONFIRMED
String to Date&Time
Inspect NEWSCALEAmount Pattern
DB Query Reader
RenameDATE_CONFIRMED_DATE
Column Renamer
Clean EDU_DESC
String Manipulation
Parse J_STARTDATE
String to Date&Time
Query distribution
DB Query Reader
Clean EDU_ABBR
String Manipulation
renameJ_STARTDATE_DATE
Column Renamer
Master grade withoutsalary detail
DB Query Reader
Check data
Column Filter
Statisti EDUMAS Status
GroupBy
Validate EDUMAS
Rule Engine
CleanMARITAL_ST
String Manipulation
Filter DuplicateEDU_KOD
Rule-based Row Filter
Datatype to Int
Double to Integer
StatisticDuplicate EDU_KOD
GroupBy
StatusMARITAL_ST
Rule Engine
Select CleanEDUMAS Columns
Column Filter
Profile NEWSCALE_D
DB Query Reader
Filter ValidEDUMAS
Rule-based Row Filter
Distribution tangga gaji
DB Query Reader
Status phone
Rule Engine
Clean TEL_NO
String Manipulation
RenameEDUMAS for F
Column Renamer
NEWSCALE_M Lookup
DB Query Reader
StatisticMARITAL_ST
GroupBy
Addleading zero
String Manipulation
StatistikPhone
GroupBy
Load TANGGUHCategory Staging
DB Writer
50: CLEANED DB
Microsoft SQL Server Connector
TANGGUH CategoryPost-Migration Summary
DB Query Reader
Export TANGGUHCategory Post-MigrationReport
Excel Writer
Truncate F EDUMAS
DB SQL Executor
50: CLEAN DB
Microsoft SQL Server Connector
CLEANED DB
Microsoft SQL Server Connector
Profile NEWSCALE_M
DB Query Reader
Table F EDUMAS
DB Table Selector
50: DBHR_POPP
Microsoft SQL Server Connector
Insert F EDUMAS
DB Writer
Profile TANGGUH Category Codes
DB Query Reader
OverallEMPMAS Validation
Rule Engine
Statistik kontrek
GroupBy
Read F EDUMAS
DB Reader
FilterREADY_FOR_F EMPMAS
Rule-based Row Filter
INVALID_RECORDS
Excel Writer
StatisticOverall EMPMAS
GroupBy
Filter Invalid EDUMAS
Rule-based Row Filter
FinalEMPMAS FColumns
Column Filter
Raw WARIS
DB Reader
Validate TANGGUHCategory Staging
DB Query Reader
FilterEMPMAS Issue List
Rule-based Row Filter
WARIS
DB Table Selector
Migrate TANGGUHCategory to PP_POSTPONE_CATEGORIES
DB SQL Executor
Write intoEMPMAS F
DB Writer
RenameEMPMAS FColumns
Column Renamer
SKIMMAS
DB Table Selector
Excel Reader
Table F JAWATAN
DB Table Selector
Statistic FJAWATANDate Status
GroupBy
Classify StaffvsVacant Position
Rule Engine
Validate SourcevsF JAWATAN Count
DB Query Reader
Statistic FJAWATAN ETL Status
GroupBy
Read MIGPP Staff Keymap
DB Query Reader
Join JAWATANwithPP Staff Keymap
Joiner
Raw SKIMMAS
DB Reader
Statistic StaffvsVacant Position
GroupBy
Microsoft SQL ServerConnector IMAS_HRMS
Microsoft SQL Server Connector
CleanSKIM_DESC
String Manipulation
CleanKOD_SKIM
String Manipulation
CleanGRED_SKIM
String Manipulation
CleanSKIM_JPA
String Manipulation
StatisticSKIMMAS Status
GroupBy
ValidateSKIMMAS
Rule Engine
Read F JAWATAN
DB Reader
FilterDuplicateKOD_SKIM
Rule-based Row Filter
StatisticDuplicate KODSKIM
GroupBy
Filter ValidSKIMMAS
Rule-based Row Filter
Filter JAWATANF Issues
Rule-based Row Filter
ValidateJAWATAN F Layer
Rule Engine
Filter ValidJAWATAN For F
Rule-based Row Filter
Create JAWATANSource Key
String Manipulation
Profile MIG-12Lookup Readiness
DB Query Reader
Select JAWATANF Columns
Column Filter
Migrate NEWSCALE to PO_POSITION_SALARY_SCALE_SSMS
DB SQL Executor
Export JAWATANF Issues
Excel Writer
Load MIG-12 NEWSCALE Staging
DB Writer
Add JAWATANF Metadata
Constant Value Column Appender
Validate MIG-12 NEWSCALE Staging
DB SQL Executor
truncate F JAWATAN
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Column Filter
Rename JAWATAN for F
Column Renamer
RenameSKIMMAS for F
Column Renamer
Insert F JAWATAN
DB Writer
Insert FSKIMMAS
DB Writer
Final FSKIMMASColumns
Column Filter
SKIMMAS
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
Read FSKIMMAS
DB Reader
Prepare MIG-12 NEWSCALE Staging
DB SQL Executor
RenameSKIMMAS to ref_service_scheme
Column Renamer
Select NEWSCALE Staging Columns
Column Filter
Insertref_service_scheme
DB Writer
Increament data check
DB Query Reader
Finalref_service_schemeColumns
Column Filter
Build NEWSCALE Combined Source
DB Query Reader
Export JAWATANMapping Issues
Excel Writer
SQL ServerConnector - AUDIT
Microsoft SQL Server Connector
Check MIG JAWATANReady Sample
DB Query Reader
Filter JAWATANMapping Issues
Rule-based Row Filter
NORMALIZED DB
Microsoft SQL Server Connector
Insert IssueLog - JAWATAN
DB SQL Executor
staff_service
DB Table Selector
Create ETL RunJAWATAN Audit
DB SQL Executor
DB SQL Executor
Upsert Audit table Log - JAWATAN
DB SQL Executor
Readref_service_scheme
DB Reader
Read staff_service
DB Reader
Checkstaff_service vsSKIMMAS
Joiner
ref_service_scheme
DB Table Selector
StatisticService SchemeLookup
GroupBy
Microsoft SQL ServerConnector IMAS_HRMS
Microsoft SQL Server Connector
StatusService SchemeLookup
Rule Engine
Validate MIG JAWATANStaging Statistic
DB Query Reader
Filter MissingService Scheme
Rule-based Row Filter
Insert MIG JAWATANStaff Services Ready
DB Writer
Read PO Positions
DB Query Reader
Set JAWATANMapping Status
Rule Engine
Set JAWATANMapping Remark
Rule Engine
Join JAWATANwith Position Levels
Joiner
Set JAWATANis_confirmed
Rule Engine
PROPOSED_SCHEME_DESC
Constant Value Column Appender
Rename JAWATANfor MIG Staging
Column Renamer
Missing ServiceScheme Summary
GroupBy
Truncate MIGJAWATAN StaffServices Ready
DB SQL Executor
Excel Writer
Add JAWATANStaging Metadata
Constant Value Column Appender
ACTION_REMARK
Constant Value Column Appender
Select JAWATANStaging Columns
Column Filter
Filter CorrectedService Scheme
Rule-based Row Filter
Load MissingService SchemeCorrection
Excel Reader
Create ServiceScheme DescFinal
Rule Engine
Create ServiceScheme CodeFinal
Rule Engine
Filter ValidService SchemeCorrection
Rule-based Row Filter
Join JAWATANwith PO Positions
Joiner
Validate CorrectedService Scheme
Rule Engine
Read PP Position Levels
DB Query Reader
SIMULATION - Truncate PP_AWARDS
DB SQL Executor
Microsoft SQL ServerConnector IMAS_HRMS
Microsoft SQL Server Connector
FilterREADY_FOR_IMASPP_AWARDS
Rule-based Row Filter
Final PP_AWARDSColumns
Column Filter
Insert IMASPP_AWARDS
DB Writer
PP_AWARDS
DB Table Selector
Validate PP_AWARDSMapping
Rule Engine
Statistic
GroupBy
Select PP_AWARDSMapping Columns
Column Filter
Rename forPP_AWARDS
Column Renamer
Postcode fr ADRS4
String Manipulation
Table FNEWSCALE_D
DB Table Selector
Remove extra column
Column Filter
Truncate F NEWSCALE_D
DB SQL Executor
Read FNEWSCALE_D
DB Reader
Capture Postcode
Rule Engine
CLEANED DB
Microsoft SQL Server Connector
EMPMAS
DB Table Selector
Filter Valid FBINTANG_M
Rule-based Row Filter
Color Manager
Define Statistic
Rule Engine
Write to F
DB Writer
Statistic
GroupBy
TruncateJAWATAN
DB SQL Executor
Remove trailing spaces
String Manipulation (Multi Column)
DB Reader
Chart
Pie Chart
Renamecolumn for F
Column Renamer
Filter column for F
Column Filter
insert staging
DB SQL Executor
validate count
DB Query Reader
insert pp_staff
DB SQL Executor
insert keymap
DB SQL Executor
Create missingBANK_DESC_FINAL
Rule Engine
Validate missingbank correction
Rule Engine
Corrected missingreference only
Rule-based Row Filter
Create missingBANK_CODE_FINAL
Rule Engine
Branch Bfinal columns
Column Filter
Update AuditIMAS ResultBINTANG_M
DB SQL Executor
Combine BranchA and B BANKCODE
Concatenate
Check AuditIMAS ResultBINTANG_M
DB Query Reader
Valid Branch Bcorrection only
Rule-based Row Filter
Branch Afinal columns
Column Filter
truncate pp_staff
DB SQL Executor
create keymap table
DB SQL Executor
Rename final BANKCODE columns
Column Renamer
IMAS_HRMS
Microsoft SQL Server Connector
Remove duplicateBANK_CODE
Duplicate Row Filter
create staging table
DB SQL Executor
Insert Issue LogBINTANG_MCount Mismatch
DB SQL Executor
Statistic
GroupBy
Check Pre MigrationView - BINTANG_M
DB Query Reader
Insert AuditTable Log - BINTANG_M
DB SQL Executor
Insert ColumnMapping Log BINTANG_M
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Final valid BANKCODE only
Rule-based Row Filter
FINAL_LOAD_STATUS
Rule Engine
Check Post MigrationView - BINTANG_M
DB Query Reader
Insert to Cleansing DB
DB Writer
CLEANED DB
Microsoft SQL Server Connector
Final BANKCODEcolumns for F
Column Filter
Column Filter
SQL ServerConnector - AUDIT
Microsoft SQL Server Connector
Create ETLRun - EMPLOY Audit
DB SQL Executor
Date column to clean
Metanode
GET Request
DB Reader
Microsoft SQL ServerConnector IMAS_HRMS
Microsoft SQL Server Connector
SQL ServerConnector - AUDIT
Microsoft SQL Server Connector
Check AuditIMAS ResultBINTANG_M
DB Query Reader
Update AuditIMAS ResultBINTANG_M
DB SQL Executor
Create ETLRun - EMPLOY Audit
DB SQL Executor
SQL ServerConnector - AUDIT
Microsoft SQL Server Connector
create table F JAWATAN
DB SQL Executor
correction load table
DB SQL Executor
JAWATAN
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
Insert AuditTable Log - EMPMAS
DB SQL Executor
Insert Issue LogEMPMASCount Mismatch
DB SQL Executor
Insert ColumnMapping Log EMPMAS
DB SQL Executor
validateorphan keymap
DB Query Reader
validate missingcritical data
DB Query Reader
validateduplicate keymap
DB Query Reader
Check Post MigrationView - BINTANG_M
DB Query Reader
Check Pre MigrationView - BINTANG_M
DB Query Reader
invalid data
DB Query Reader
truncate EMPMAS
DB SQL Executor
Postcode fr ADRS3
String Manipulation
Int to String
Number to String
Add padleft 0
String Manipulation
Postcode fr ADRS2
String Manipulation
Remove space empty
String Manipulation (Multi Column)
Create IMAS mig staging
DB SQL Executor
Statistics
Metanode
StatusJ_STARTDATE
Rule Engine
Check akhir < mula kontrek
Rule Engine
Convert to date
String to Date&Time
Column Filter Widget
Excel Writer
Convert JAWATANNumber to Integer
Double to Integer
Convert JAWATANInteger to String
Number to String
Value Counter
Raw JAWATAN
DB Reader
Rename RawJAWATAN Columns
Column Renamer
Clean POST_STA
String Manipulation
Clean POST_REF
String Manipulation
Handle Missing JAWATAN String Columns
Missing Value
Clean JAWATANNumeric Strings
String Manipulation (Multi Column)
SOURCE: SHORTLIST
Microsoft SQL Server Connector
Table BANKCODE
DB Table Selector
Raw BANKCODE
DB Reader
Clean BANK_CODE
String Manipulation
BANKCODE NOTES
Text View
Clean BANK_DESC
String Manipulation
Filter ValidIKTISAS_M
Rule-based Row Filter
Export invalid
Excel Writer
Filter InvalidIKTISAS_M
Rule-based Row Filter
RenameIKTISAS_M for F
Column Renamer
Select CleanIKTISAS_MColumns
Column Filter
Table FIKTISAS_M
DB Table Selector
Truncate F IKTISAS_M
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Read FIKTISAS_M
DB Reader
Insert FIKTISAS_M
DB Writer
Status Validation
Rule Engine
Statistik
GroupBy
AHLI_IKTISAS
DB Table Selector
Raw AHLI_IKTISAS
DB Reader
ConvertAHLI_IKTISASInteger to String
Number to String
ConvertAHLI_IKTISASNumber to Integer
Double to Integer
Clean IKTISAS_CD
String Manipulation
Clean NO_GAJI
String Manipulation
StatisticAHLI_IKTISASStatus
GroupBy
ValidateAHLI_IKTISAS
Rule Engine
Filter DuplicateAHLI_IKTISAS
Rule-based Row Filter
DuplicateCheck AHLI_IKTISAS
GroupBy
Export duplicate
Excel Writer
Filter InvalidAHLI_IKTISAS
Rule-based Row Filter
Filter ValidAHLI_IKTISAS
Rule-based Row Filter
Select CleanAHLI_IKTISASColumns
Column Filter
Export invalid
Excel Writer
Add PendingIKTISAS LookupStatus
Constant Value Column Appender
RenameAHLI_IKTISAS for F
Column Renamer
Table FAHLI_IKTISAS
DB Table Selector
Read FAHLI_IKTISAS
DB Reader
CLEANED DB
Microsoft SQL Server Connector
Insert FAHLI_IKTISAS
DB Writer
Truncate F AHLI_IKTISAS
DB SQL Executor
BINTANG
DB Table Selector
Raw BINTANG
DB Reader
Convert BINTANGInteger to String
Number to String
Convert BINTANGNumber to Integer
Double to Integer
Clean BINTANGNumeric StringColumns
String Manipulation (Multi Column)
Handle MissingBINTANG NumericString Columns
Missing Value
Clean BTNG_DESC
String Manipulation
Clean BTNG_JENIS
String Manipulation
Status BTNG_DATE
Rule Engine
Filter ReadyBTNG_DATE
Rule-based Row Filter
PrepareBTNG_DATEParse Value
Rule Engine
Rename toBTNG_DATE_PARSED
Column Renamer
Parse BTNG_DATE
String to Date&Time
Statistic BINTANGStatus
GroupBy
Validate BINTANG
Rule Engine
StatisticBTNG_DATE_STATUS
GroupBy
Statistic BTNG_JENIS
GroupBy
DuplicateCheck BINTANG
GroupBy
Export duplicate
Excel Writer
Filter DuplicateBINTANG
Rule-based Row Filter
Filter Invalid BINTANG
Rule-based Row Filter
Filter Valid BINTANG
Rule-based Row 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: hanif
Created at: 2026-04-24
On NodePit since: 2026-08-05
Last update: 2026-08-13
Created with KNIME version: v5.11.0

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

Try NodePit Runner!