SQL task
SQL task
This scenario demonstates using of SQL Task.
drop_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
auto
drop table staging_employee
create_staging_table
com.toolsverse.etl.core.task.common.SqlTask
dest
auto
create table staging_employee ( EMPNO varchar(6), FIRSTNME varchar(12), LASTNAME varchar(15), JOB varchar(8), GLOBAL_VAR varchar(100), LOCAL_VAR varchar(100) );
staging_employee
select * from employee
copy
dest
com.toolsverse.etl.core.task.common.SqlTask
auto
insert into staging_employee values ({EMPNO}, {FIRSTNME}, {LASTNAME}, {JOB}, {GLOBAL_VAR}, {TASK_VAR});
GLOBAL_VAR,TASK_VAR