Create MySql function and use it in the etl scenario. Use Scenario global variable
Create MySql function and use it in the etl scenario. Use Scenario global variable
com.toolsverse.etl.driver.mysql.MySqlDriver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
to_value
CREATE FUNCTION to_value(v_value INT) RETURNS CHAR(6) BEGIN RETURN CAST(v_value AS char); END;
employee
employee_function
true