Before and after tasks
Before and After tasks
This scenario demonstates before and after tasks.
auto
drop_staging_table_before
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
employee_cursor
employee_before_after
true
drop_staging_table_after
dest
com.toolsverse.etl.core.task.common.SqlTask
drop table staging_employee