Using MySql procedural language in the etl scenario
Using MySql procedural language in the etl scenario
Using MySql procedural language in the etl scenario
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
employee
employee_mysql
true
if {SEX} = 'M' then if {EMPNO} = '000230' then set {EMPNO} = {EMPNO}; end if; insert into employee_mysql (EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX) values ({EMPNO},{FIRSTNME},{MIDINIT},{LASTNAME},{TEST},'M'); end if;