Create TransactSQL function and use it in the etl scenario. Use Scenario global variable
Create TransactSQL function and use it in the etl scenario. Use Scenario global variable
com.toolsverse.etl.driver.sqlserver.MsSqlDriver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
to_value
create function to_value(@v_value int) RETURNS CHAR(6) AS BEGIN return CAST(@v_value as char(6)); END;
employee
employee_function
true