Using PL/pgSQL in the etl scenario
Using PL/pgSQL in the etl scenario
com.toolsverse.etl.driver.postgres.PostgresDriver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
employee
employee_pgsql
true
if {SEX} = 'M' then insert into employee_pgsql (EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX) values ({EMPNO},{FIRSTNME},{MIDINIT},{LASTNAME},{TEST},'M'); end if;