Informix Extract and Load using DbAccess
Informix Extract and Load using DbAccess
com.toolsverse.etl.driver.informix.InformixDriver
EXTRACT_LOAD
drop_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
DROP TABLE employee_stage;
create_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
create TABLE employee_stage ( EMPNO CHAR(6) not null, FIRSTNME VARCHAR(12) not null, MIDINIT CHAR(1), LASTNAME VARCHAR(15) not null, WORKDEPT CHAR(3), PHONENO CHAR(4), HIREDATE datetime year to second, JOB CHAR(8) );
extract
source
com.toolsverse.etl.core.task.informix.InformixExtractTask
com.toolsverse.etl.driver.informix.InformixDriver
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from employee
load
dest
com.toolsverse.etl.core.task.informix.InformixLoadTask
com.toolsverse.etl.driver.informix.InformixDriver
employee_stage
employee_table
true