Create pgSQL function and use it in the etl scenario. Use Scenario global variable
Create pgSQL function and use it in the etl scenario. Use Scenario global variable
com.toolsverse.etl.driver.postgres.PostgresDriver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
to_value
to_value(v_value in integer)
create or replace function to_value(v_value in integer) RETURNS CHAR AS $$ BEGIN return to_char(v_value, 'FM999999'); END;$$ LANGUAGE plpgsql;
employee
employee_function
true